You can use SELECT-SQL. It will redimention array to the number of records selected. The array wouldn't change if select returns 0 records. SELECT * ;
FROM mytable ;
INTO ARRAY laMyarray


>Is there an easy way to laod a 2 dimensional array from an existing
>table?
>
>Will the array expand automaticly if the rows exceed the orignal
>declaration?
>
>Thanks
>Andy