> you need some user-dedicated or terminal-dedicated generators to do
> this.
>
> create generator JASA_RN -- jasa's row numarator
>
>
> you need to clean its value before use it each time.
> select gen_id(JASA_RN,-GEN_ID(JASA_RN,0)) from rdb$database;
>
> then:
>
> select gen_id(JASA_RN,1), myfield1, myfield2
> from mytable
> where mycontitions

Using generators for this purpose is NOT multi-user safe.

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