Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select Into Array changes current work area
Message
 
 
To
22/04/2005 09:31:39
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01007432
Message ID:
01007435
Views:
14
>This is code:
<snip>
>What's wrong?

Hi Sergey,

It's a bug, IMO. No command should change workarea randomly. Here's a simpler repro.
CLEAR
CLOSE DATA
CREATE CURSOR Test (nnn I)

SELECT Test
? SELECT()     && 1 - correct
SELECT * FROM Test ;
	JOIN (SELECT nnn FROM Test ) dt1 ;
	ON Test.nnn = dt1.nnn ;
	INTO ARRAY myarray
? SELECT()     && 5 - Incorrect, shold be 1
 
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform