Subject Re: [firebird-support] "In List" - Can list be a parameter?
Author Aage Johansen
ra8009 wrote:
>
> I'm using Firebird with IB Objects. I need to submit a list as a
> paramter in this statement:
>
> SELECT * FROM MYTABLE WHERE ID IN (:MYLIST)
>
> Is there a way to make this work without having my code supply a new
> SQL statement each time?


Put the values in MYLIST in a table, and use JOIN.

--
Aage J.