Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Seek not working intermittently
Hi.
I have an app where it appears that a Seek is not working intermiitently.
I have a table as follows:
Cur.MyField
-----------------
A
B
C
D
Which seeks another table
Scan
X=Cur.MyField
Sele MyLookup
Seek X Order MyOrder
If Not eof()
Do something
Endif
Endscan
The seek on the third line of the Table above (C) sometimes gets a wrong record (e.g. might get B instead)
This happens very infrequently (Maybe Twice a day out of 5,000 seeks)
The Table taht is being Looked up is Locked ( as data nay be inserted and amended)
The Lookup Table has about 30,000 records , with about 40 fields
As a general rule,Seems to be happening on very busy period of the day, and also near break times(e.g. Lunch time, End of day)
This is only happening in one place in a fairly large APP.
Has anybody come across any issues like this ...I have reengineered the code and tried all sorts but
it still seems to be intemittently getting a wrong Seek
Tia.
regards,
Gerard
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