Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select with IN clause is giving an error
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows Server 2003
Database:
Visual FoxPro
Divers
Thread ID:
01154265
Message ID:
01154275
Vues:
9
>Can you give me an example. I tried doing this WHERE &lcWhere (SELECT mtgid FROM yourcursor). But getting an error

Did you create your cursor with the values in it?
CREATE CURSOR mtgids (mtgid I)
INSERT INTO mtgids values (1)
INSERT INTO mtgids values (2)
etc.
Then you'd need:
SELECT whatever FROM yourtable WHERE mtgid IN (SELECT mtgid FROM mtgids) INTO...
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform