>>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
>
>AFAIK you can not add more than 1 index if the cursor is not created with readwrite clause. And if it is, then NOFILTER is redundant.
If this were the case, I would get the error on my computer. And the customer would get the error every time. But it is not so.
"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