> Does anybody knows how can I set a new generator value inside a
> procedure or trigger?.

You can't. DDL (Data Definition Language) statements aren't allowed
in stored procedures and triggers.

To reset a generator you could try something like that:

GEN_ID (MyGen, 0 - GEN_ID (MyGen,0) );

But, this is *NOT* safe in a multiuser environment!!!



Regards,
Thomas Steinmaurer
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com