Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No table is open in the current work area
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01065292
Message ID:
01065294
Views:
21
WAG. Do you have a timer that could fire at the time of error and run code that could change a work area?

>O wise ones, I am getting the "No table is open in the current work area" error in in VFP9 in places that have - I am sure - worked fine since VFP6. This is a recent example:
>
>cID = "XYZ"
>IF SEEK(cID, "DataTable", "ID")
> SELECT DataTable
> WAIT My_Names WIND && just see where we are
> SKIP IN DataTable && I wanted to leave the first occurrence
> DELETE WHILE DataTable.ID==cID && then delete any others
>ENDIF
>
>The error was thrown on the 'DELETE WHILE' line and was cured by adding an 'IN DataTable' clause, which is good practice anyway.
>
>* Here's another example:
>SELECT (cSourceTable)
>SCAN
> * some code
> SCATTER MEMO NAME oTmp
> * some more code - modifies / tests fields
> = GetNewRecord(cDestinationTable)
> SELECT (cDestinationTable)
> GATHER MEMO NAME oTmp
> SELECT (cSourceTable)
>ENDSCAN
>
>The error was thrown at the SCATTER and GATHER lines.
>But why?
>
>John Burton
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform