Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Select
Message
De
05/12/2001 21:35:42
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL Select
Divers
Thread ID:
00590311
Message ID:
00590311
Vues:
67
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...
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform