Subject Re: [firebird-support] IN function
Author Alexandre Benson Smith
yartax1 wrote:
> Hi,
> I want to do next query within a procedure:
> Select * from table where field_integer in ( :mylist )
> Where mylist is a variable with data as like as '123,345,342'. I
> suppose that fb considers field as numeric and commas are considered
> as decimal point.
> In any case how can I do a similar where clausule without doing
> another query or creating a temporal table? In a previous step I got
> field values and inserted in a variable, it would be more efficient
> that requery previous steps and join results with this new query.
> thanks,

Have a look on the messages history, this kind of problem has appeared

One way is to use EXECUTE STATEMENT another is to parse the string in a
loop and return each result set.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil