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,
>
>

Yartax,

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

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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br