Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select
Message
From
05/12/2001 21:35:42
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL Select
Miscellaneous
Thread ID:
00590311
Message ID:
00590311
Views:
66
Hi all,

I hope someone can explain the phenomenon I'm seeing at below in command window :

Case 1:
=======
SELECT * FROM demas INTO CURSOR ABC
SELECT cnoee FROM ABC INTO CURSOR BCD
Error Message : ABC must be created with Select ... INTO TABLE

Case 2:
=======
SELECT * FROM demas INTO CURSOR ABC NOFILTER
SELECT cnoee FROM ABC INTO CURSOR BCD
No error message.

Case 3:
=======
SELECT dxand.*,cname FROM dxand,demas WHERE dxand.cnoee=demas.cnoee INTO CURSOR ABC
SELECT cnoee,cname FROM ABC INTO CURSOR BCD
No error message.

Thanks in advance...
Next
Reply
Map
View

Click here to load this message in the networking platform