I tend to put go bottom. go top into my UDF code when using small tables without indexes just 'to be safe'.

Historically, it seemed to flush/refresh buffers and eliminate eof() errors, also if a FILTER was turned on and I was sitting on a record that was NOT in the filtered group, Fox would report that record as part of the selected data.

So, when writing code for small non indexed tables, I just include those two lines. If it saves one crash a year, I figure I win!

I should add that I do NOT do this on large indexed tables, just the small busy ones!

As I posted later, seems that adding UNLOCK after a REPLACE command made the change visible to other users about FOUR SECONDS sooner ! ( no matter what I set REFRESH to, or using FLUSH, etc! )

thx

mike