Subject Re: [firebird-support] Re: Record numbering
Author Martijn Tonies
> 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
My thoughts:
Database development questions? Check the forum!