> The only safe way to do it in a C/S world is via a stored proc:

Or via a client-side select:

SELECT GEN_ID(GenName, 1) FROM RDB$DATABASE

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."