Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT statement overlap my workarea
Message
From
11/10/2001 09:04:32
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SELECT statement overlap my workarea
Miscellaneous
Thread ID:
00566892
Message ID:
00566892
Views:
44
hi,
I have problem that, SELECT-SQL ...INTO CURSOR statement may "overlap" my opened workarea.
USE mytable ALIAS tbl1 IN 1
USE mytable2 ALIAS tbl2 IN 2

**the code above work fine
SELECT * FROM mytable3 WHERE f1 = "A" INTO CURSOR csrTemp
VFP doesn't create the cursor on workarea 3, instead it may overlap the previous workarea..work area 1 or 2.. so.. i try to not open any tables on that workarea which VFP will always create the cursor in. It work fine at my office. However, the error occured again if i move my project to other computer!!!

How to solve this?

Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Next
Reply
Map
View

Click here to load this message in the networking platform