Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error File is Not Open
Message
From
16/09/2015 09:33:35
Bruno Maddalozzo
Informatica Aziendale
Arsie, Italy
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01624619
Message ID:
01624683
Views:
41
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform