Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error File is not open - 1113
Message
 
To
16/11/2016 16:08:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01643575
Message ID:
01643576
Views:
46
>Hi,
>
>I have in my scan...endscan procedure an error 'File is not open'
>The error occurs on line endscan
>procedure (simplified)
>
>select myCursor
>scan
>   if llCondition 
>      create cursor myCursor2  (field1 i, field2 m)
>      select myCursor
>      scatter name m.loCursor2 memo
>      Select myCursor2
>      Append Blank
>      Gather Name m.loCursor2 Memo
>      select myCursor
>   endif
>endscan
>
>
>debugger shows that on start and on end myCursor = alias() also myCursor2 is correctly populated with content of myCursor
>where should I put a try...catch to catch this error?
>
>Regards,
>Koen

In debugger open breakpoint dialog and Select:
"Break when expression is true"
and in Expression put:
SELECT("myCursor") == 0

Check the picture.

BTW this code is weird :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform