Hello NAS,

N> why it's not work :
N> id_xx=gen_id(:param1);
N> param1 is varchar
N> I use Firebird 1.52
AFAIK, you can't use such construction. As a workaround refer to
EXECUTE STATEMENT (see release notes), something like
-----
stmnt = 'select gen_id(' || param1 || ', 1) from rdb$database';
execute statement stmnt into :id_xx;
-----


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com