In it's simplest form:

DIMENSION aArray[1]
aArray[1] = 1
FOR x = 2 TO 10
   DIMENSION aArray[x]
   aArray[x] = x
ENDFOR

That will ultimately give you an array of 10 items containing numbers 1 to 10

As far as the SQL is concerned, when you do a SELECT into an array, the array returned is automatically the correct size. If you use an array that is already in existence, it will be resized as needed.

Alan

>sb,
>
>Do you have code examples of this? I'd love to see one
>with SQL if you have that as well.
>
>fz