How I can make in query that have In -clause

Data Abstract
1

I was trying to use simple string parameter to have query something like this

Select * from TABLE where ID IN (:AListOfParameters)

And it failed, so I ran out of ideas how I do something like that???

Where clause is more complicated than that and should have some parts defined at server side, but any way to have such an list would be cool…

-Tee-

2

Maybe this can be done with an TDABusinessProcessor?? Maybe… But How I can pass the parameters nicely etc…

3

Hello,
You can use DynamicWhere feature for this purpose. Please read about it in wiki:
http://wiki.remobjects.com/wiki/Dynamic_Where
http://wiki.remobjects.com/wiki/ListExpression

4

Thanks…