Hi,

> I am wondering if any similar statement or perhaps a trick to do the job
> in stored procedure in Firebird?

Well... you could do this:

insert into table
select :new_key, field2, field3, ... from table
where field1=:old_key;


But still needs to declare field list (same order as defined in the table).
At least you don't have to declare any variables.


Regards,
Anderson