> Hi Martijn,
>
> i never wrote any singleuser/standalone application in my life,
> so i never faced with single-user safety. ;)

Huh?

I said: it's not multi-user safe.

If multiple users use that same generator for that purpose, you will
get weird increments in your resultset.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

> here is what i said:
> > > you need some user-dedicated or terminal-dedicated generators to do
> > > this.
> > >
>
> every user(the login person) and terminal should be singular in my mind.
>
> because of users and terminals are limited and manageble, there is no
> so much risk about generator table overflow and one time used zombie
> generators.
>
> the only soft-risc is a local problem:
> user may run more than one numarator based query at the same time.
> a clever programmer can solve this problem without panic i think...
>
> Regards.
>
> Ali