Unfortunately you can't pass a set of fields into a stored procedure.
You could pass it in as a varchar, and parse the strings.

Adam


--- In firebird-support@yahoogroups.com, "Nikolay Marinov"
<kok_bg@y...> wrote:

>
>
> Hi all !
> Using Firebird 1.5.
> I need to put some values in variable, for later use with IN()
> operator in a stored procedure.
>
> .....
> declare variable ParentIds varchar(1024)
> .....
>
> ParentIds='1,2,3,4';
>
> select ... where "Id" IN(:ParentIds)
>
> This return error 'Incompatible column/host variable data type.'
> Any idea how to resolve this ?
>
> if the value in variable is single - ParentIds='2' - there is no
> problem.
>
> Thanks!