>>Hi everybody,
>>
>>I have the following code
>>
>>
>> this.mysqlexec(m.lcSQL,'csrTables', program())
>> this.addproperty('aTables[1]')
>> dimension this.aTables[reccount('csrTables')]
>> copy to array this.aTables fields table_name
>> use in select('csrTables')
>>
>>I found that only the first row value is properly copied and the rest of the values remain false. Do you see a bug in this code? The csrTables has 13 rows and only the first row value is copied into that array.
>>
>>Thanks in advance.
>
>That's because your array has only one row
Actually, it was because her array had only one _column_. COPY TO ARRAY pays attention to whether the array is 1-d or 2-d.
Tamar
>
>Try
>
> dimension this.aTables[reccount('csrTables'), 1]
>copy to array this.aTables fields table_name
>