Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select table does not change default work area
Message
From
10/06/2009 13:52:05
 
 
To
10/06/2009 13:06:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01404959
Message ID:
01405011
Views:
43
>It is somehow tied to the grid of the calling form, becuase the cursor that is selected is the recordsource for that grid. There is a timer on that form, but it does not do anything with that grid.
>
>What I ended up doing is putting "Select Request" at the top of all procedures on the calling form that use it. It may not solve the problem per se, but it does resolve the issues I was having. The code in the INIT() does seem to work as long as I don't put a set step in there to watch it. What appears to be happening is as soon as the system gets a free cycle or two it is running 'something' from the calling form that changes the current work area.

FWIW, I don't have very much code anymore that cares what the current work area is. I make sure to add the IN clause wherever I can, and specify the alias in all function calls that accept it. That gets me down to just a few commands that care about the current work area.

Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform