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

or, he could simply insert the values into a separate table and then
do a JOIN to this table.

Set

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