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:
11
>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