> > I might be at the tail end of the thread, but what's wrong with an
> SP that
> > returns the ID. We do it all the time...
>
> There is nothing wrong with that approach. But it has one
> disadvantage: Maintaining!

Because generators are not tied to any particular field,
you can have single generator (and SP to retrieve it) for whole database.

Ivan
prenosil@...
http://www.volny.cz/iprenosil/interbase