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