Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Intermittent errors
Hello,
My VFP6/7 application seems to crash occasionally on one of lines 42 & 110:
# 41 Select * From H332Ea Where fk_H332 = lnH332 Into Cursor crsH332Ea
# 42 Select * From crsH332Ea Where Between(Src,[2],[7]) Into Cursor crsSrc27
# 43 Select * From crsH332Ea Where LineNum = [01] And GeoTool = [DS] Into Cursor crsDSLine
# 44 etc...
# 110 If RecCount([crsSrc27]) = 1
# 111 etc...
The 2 errors that show up in my error log are:
Line 42: File crsH332Ea does not exist
and
Line 110: Alias is not found (crsSrc27)
My questions are:
1- Is it not true that the cursor is going to be created regardless of
whether or not it has results in it ? (line 42 error)
2- Considering that the app exists after an error; how can line 110 have
that error if line 42 didn't crash
3- Same app, same data, different days will either work fine or have one of
the 2 errors !!!
Note that all these lines are in a Scan loop and run every time. They are
NOT skippable with IF or other constructs.
Any ideas ?
Henry
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