Mistery solved. Between the first and second call I opened the table under a different alias. VFP was smart enough to know it is the same table and used it without opening it again under the same alias as before.

Thanks for the help.

ALe

>Hi Alex,
>
>I think it's time to use debugger to step throgh the code and watch what's going on.
>
>>That is what I have always thought, Sergey, but in this case the table definitely was not open (alias was not used and table does not show in the data session window) before the second time select was issued, the array was filled correctly by the select, and the table was not opened by the select. Very weird. Based on your comment I checked SET('SQLBUFFERING') and it was 'OFF'.
>>
>>tcDataDict = 'DD_Fac_Int' which is the stem of the DBF and also the Alias.
>>
>>What can be happening? Thanks for the help.
>>