Thank you, Bruno. I will try this too.
>I would try to delay the single statements like that:
> INDEX ON FIELD1 TAG FIELD1
>Wait window "Indexing..." Timeout 3
> INDEX ON FIELD2 TAG FIELD2
>Wait window "Indexing..." Timeout 3
> INDEX ON FIELD3 TAG FIELD3
>Wait window "Indexing..." Timeout 3
> INDEX ON FIELD4 TAG FIELD4
>Wait window "Indexing..." Timeout 3
> INDEX ON FIELD5 TAG FIELD5
>Wait window "Indexing..." Timeout 3
> INDEX ON FIELD6 TAG FIELD6
>Wait window "Indexing..." Timeout 3
>
>and see if it happens again.
>
>HTH
>
>Bruno
>
>
>>>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
>>
>>Adding NOFILTER to the SQL Select did not resolve the problem. The customer still gets the error. I will set the TRY CATCH between each line of code above to see if I can "catch" more specifically the offending line.
"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