>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

SELECT field1, field2 FROM yourtable INTO ARRAY yourarray

This will give you an array sized to the number of records from the table. You can limit the records using a WHERE clause on the SELECT statement. If there are no records selected, the array won't get created if it doesn't exist, nor will it be resized if it did already exist. You can check for the number of records by using the _TALLY system variable after the SELECT.