David,
You can use textmerge to build your query
TEXT TO lcSql TEXTMERGE NOSHOW PRETEXT 7
Select * From Accounts Where RefNo in (<<crefno>>)
ENDTEXT
lnResult = SQLEXEC(lnConn, lcSql)
...
>Hi,
>
>I am selecting multiple rows from a list box and based on selected values, I like to query the datasource using sql pass through.
>
>Select * From Accounts Where (RefNo in (?crefno) )
>
>where crefno is '1','11','121','aaaa'
>
>This method works for a single value but not for a group of values. Any advice?
>
>Regards,
--sb--