>>Knowing that SQL select won't read the buffers, I used the Copy To Array, and, since this array will be needed elsewhere in the form, did something like "copy to array thisform.aArray". The array property was dimensioned aa aArray[1,0]. It invairably copied only one row.
>>
>>In all other cases, the arrays are redimensioned as the "copy to" command requires (or am I wrong?). Does this mean that array properties are an exception?
>
>I did not use this command (COPY TO ARRAY) for a while, but now doing quick test I see that any array should be redimensioned first to accomodate all table elements, or as it's said in help: " If the array has fewer elements than the table has fields, any remaining fields are ignored." and "If the array has fewer rows than the table has records, any remaining records aren’t stored to the array.". Not very logical but seems to be true.
This seems to be an exception to all other commands which create arrays. This one seems to be an exception - all the others redimension arrays automatically.
I'll have to remember this one.