>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.
What about READWRITE clause?
If it's not broken, fix it until it is.
My Blog