Hi,
I have trapped (using Try / Catch) an error "File is not open" in the following section of the code:
IF SELECT("V_WO_NUM") > 0
SELECT V_WO_NUM
INDEX ON FIELD1 TAG FIELD1
INDEX ON FIELD2 TAG FIELD2
INDEX ON FIELD3 TAG FIELD3
INDEX ON FIELD4 TAG FIELD4
INDEX ON FIELD5 TAG FIELD5
INDEX ON FIELD6 TAG FIELD6
SET ORDER TO TAG FIELD3
ENDIF
Before the above code the cursor V_WO_NUM is created by SQL SELECT (getting data from a VFP table).
What could possible be wrong with the above (not one time but almost every other day) that it causes the problem? And I could never duplicate this error on my PC.
TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham