GEN_ID(mygen,-GEN_ID(mygen,0)); -- set to zero
GEN_ID(mygen,(select max(myidfield) from mytable)); -- set to max id

Ali

--- In firebird-support@yahoogroups.com, "majstoru" <majstoru@...>
wrote:

>
> Hi,
>
> How can I write a SP or query statement in the FirebirdSQL that will
> set all Genrators to 0, or to get last value from tables and put it

in

> to the generator value?
>
> Thanks for support!
>