Subject Re: [firebird-support] Serial number in a query result
Author Thomas Steinmaurer
>> That trickiness appears in the FAQ: "How to get record number as part of
>> dataset?"
>> A throw-away SEQUENCE would also do the trick, I think:
>> sql> create sequence AdHoc;
>> sql> select next value for AdHoc as SrNo, d.* FROM (...) d;
>> -Mike
> This is exactly what I want.

Needless to say, if the generator/sequence is used by multiple users,
then this isn't safe.

With regards,

Thomas Steinmaurer
Upscene Productions

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!