Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized IN
Message
From
22/04/2009 20:56:10
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Parameterized IN
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01396004
Message ID:
01396004
Views:
135
SQLEXEC(lnConnection,"SELECT * FROM myTable WHERE employee = ?emp")
pops up a little dialog box and allows entry of a name to search against.

I want to use the same functionality with IN
SQLEXEC(lnConnection,"SELECT * FROM myTable WHERE employee IN (?emp)")
If I put in
NAME1,NAME2
I get nothing back
If I put in
"NAME1","NAME2"
I get just the first record

How can I format the dialog response (or how else can I set up the query) to get the two (or any number of) names

(I'm sure there are lots of other ways of doing this, but all I'm really interested in is how to do this with the parameterized query.)

Thanks to all

............Rich
Next
Reply
Map
View

Click here to load this message in the networking platform