> Hi, you could make it work with "execute statement" which allows

you to execute dynamically created sql in strings.

>
> If you use 2.1 I would recommend creating a GTT, something like

this:

> create global temporary table ids(id integer not null) on commit

delte rows;

>
> then you modify your procedure like this:
>
> CREATE PROCEDURE UpdateByParentID (AValue integer)
> AS BEGIN
> UPDATE SomeTable SET SomeColumn = :AValue
> WHERE ParentID in (select id from ids);
> END;
>
> With setup like that, you can insert ids into a gtt, and withing

same transaction execute a procedure. After you commit all rows will
be deleted from gtt.

> Check the docs for more info.
>
> Sasha

Sasha and Martijn,

Thanks!

Your input works great!

-Eduardo