Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error File is Not Open
Message
From
15/09/2015 15:11:58
 
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:
01624645
Views:
40
When you created the cursor, was it based on more than one table, or was it only one table. If the latter, did you use the NOFILTER clause?

>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform