Hi!

"?" works for a single value only. Use other approaches:
1. Use WHERE Field IN (SELECT ...)
2. Use WHERE Field IN (List Of Values)
3. Create view on the fly using & (macro). this way you can build 1. or 2. query easy. Or even like following:
str=[CREATE SQL VIEW tranmemo remote connection novtrans as SELECT * FROM tranmemo ;
WHERE ssFno = '73827282' OR ssFno = '7627272' OR ssFno = '8745949' OR ssFno = '7376478']
&str

You can use also SQLEXEC function and similar (SQL Pass Through) to send a query to server directly.


>I have created a view and it works fine when I use one string as the variable Ex:
>
>PASS1: Works Fine
>lcPendCds = '73827282'
>CREATE SQL VIEW tranmemo remote connection novtrans as SELECT * FROM tranmemo ;
> WHERE ssFno = ?lcPendCds
>
>When I add a few more parameters:
>
>Pass2:
>lcPendCds = " '73827282' OR '7627272' OR '8745949' OR '7376478' "
>CREATE SQL VIEW tranmemo remote connection novtrans as SELECT * FROM tranmemo ;
> WHERE ssFno = ?lcPendCds
>
>The second pass blows up. Is there a why pass all of these parameters?