Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select with IN clause is giving an error
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows Server 2003
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01154265
Message ID:
01154275
Views:
8
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform