Hi Jim!

I agree with you, and now I see, why worked my workarounds.
But which statements forces fox to reread the table from disk?

Bela


>>Hi Everybody!
>>
>>I have an old fox program. which I got back with a strange behaviour.
>>(The problem described here, didnot occur till now, because all data was imported at start - explanation follows)
>>The program runs on network.
>>
>>There is a sure empty table. (ITEMS)
>>
>>use items again alias firstopen
>>
>>do myproc && this proc add some records
>>select firstopen
>>go top
>>&& after this, the EOF() still TRUE!!!
>>
>>use
>Bela,
>
>Try adding this to your code;
>
>use items again alias firstopen
>
>do myproc && this proc add some records
>select firstopen
>DO WHILE NOT RLOCK()
>ENDDO
>UNLOCK
>go top
>&& after this, the EOF() still TRUE!!!
>
>use
>
>I'll bet your not at eof after that. The reason is that the lock and unloack forces fox to reread the table from disk and it then sees those new records.