Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
COM/DCOM et OLE Automation
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement