Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT statement overlap my workarea
Message
 
 
To
11/10/2001 09:04:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00566892
Message ID:
00566894
Views:
12
>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

First, foxpro wouldn't do that. Second, NEVER specify work areas in your code. It makes the code unreadable and hard to maintain. Instead tell foxpro to open the tables in the first free area
USE mytable ALIAS tbl1 IN 0
USE mytable2 ALIAS tbl2 IN 0
and later reference the tables only by there aliases in the code.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform