I did Sergey, and watched very carefully the data session window. I'll create some code to reproduce the effect.

Alex

>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.
>>