>> That trickiness appears in the FAQ: "How to get record number as part of
>> dataset?" http://www.firebirdfaq.org/faq343/
>>
>> 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
http://www.upscene.com
http://blog.upscene.com/thomas/

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