Is it possible to use parameters with IN operator?

I would like to produce a list of noncontiguous records based on an Column of Integer type.

"Where IN (:Values)"

Will this work?
And how do I assign the parameters using ParamByName in code?

Petter

>Is it possible to use parameters with IN operator?

No, neither DBISAM nor ElevateDB allows this

>I would like to produce a list of noncontiguous records based on an Column of Integer type.
>
>"Where IN (:Values)"
>
>Will this work?
>And how do I assign the parameters using ParamByName in code?

You have to build the SQL in code. You can sort of do it by putting the sql into the query then doing something like

query.sql.text := StringReplace(query.sql.text,':Values','my comma separated in string',[rfIgnoreCase,rfReplaceAll]);

Roy Lambert

Roy,

To bad - it would have been convenient in this case - it's a quite extensive script for generating a report...

I guess that I will have to do this like You suggest.

Thanks
Petter



Roy Lambert wrote:

Petter

>Is it possible to use parameters with IN operator?

No, neither DBISAM nor ElevateDB allows this

>I would like to produce a list of noncontiguous records based on an Column of Integer type.
>
>"Where IN (:Values)"
>
>Will this work?
>And how do I assign the parameters using ParamByName in code?

You have to build the SQL in code. You can sort of do it by putting the sql into the query then doing something like

query.sql.text := StringReplace(query.sql.text,':Values','my comma separated in string',[rfIgnoreCase,rfReplaceAll]);

Roy Lambert