sql to create a new table including an array

[thibault]

create table arrayx(field1 character(10), field2 integer extent 3).<br>
<br>
** Unable to understand after -- "create table arrayx". (247)<br>
** Could not understand line 1. (198)<br>
<br>
can't find any way to create a table with an array using SQL. anybody out there know how?<br>
<br>
bobbie "in chicago"

 

[jnicho02]

Best tip is to try the "Microsoft: SQL Server" forum ;-)

 

[thibault]

to jnicho02:<br>
thanks for the advice, but i couldn't pull my question once i realized i was in the wrong forum....smarty pants<br>
ps: it's not ms sql. it's progress 4gl sql.

 

[Guest_imported]

I'm working with MS Access97 and I would like to place the results of a SQL query into an array to perform data manipulation. How can I get the data into the array?