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