> Then you could use something like this:
>
> GEN_ID (GENERATOR, NEWVALUE - GEN_ID (GENERATOR,0) );

Right, but this isn't safe in a multi user environment.

Anyway, I don't know if you got my reply to your initial
posting ;-).



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