Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error File is not open - 1113
Message
From
16/11/2016 18:08:50
 
 
To
16/11/2016 16:26:50
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
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:
01643582
Views:
37
>Koen,
>
>Weird error. Is mycursor selected from another cursor or table that gets closed? Sometimes VFP will simply filter the FROM alias to mimic a new cursor. Adding NOFILTER to your SELECT statement might fix it.
>
>Alternatively: I realize you've condensed the code - but would it be possible to replace the SCAN with something like
>
create cursor myCursor2  (field1 i, field2 m)
>append from dbf('mycursor') for llcondition
>
>or even
>
select field1,field2 from mycursor into mycursor2 where llcondition
>
>- You could try commenting out that final SELECT mycursor at the end, since ENDSCAN does that implicitly. I don't think that's what's causing this, though.
John,
Mycursor is not selected from an other table/cursor that gets closed. It is selected from a table which remains open.
The changements you advised are not so easy to be done - to lengthy to give the full reason, not that I want to keep it to myselve. The code used to work without any problem for lengthy time. The last line
select myCursor
was inserted just to be 100% sure the scanned alias is selected after the last using of myCursor2, I suppose it can be removed.
The solution as proposed by Boris does not work, since in my debugger alias()==0 shows always .T. even on the line before endscan, still the error occurs on the line endscan.
I am truly puzzled.
Regards,
Koen
Previous
Reply
Map
View

Click here to load this message in the networking platform