|Subject||Re: [firebird-support] Serial number in a query result|
>> That trickiness appears in the FAQ: "How to get record number as part ofNeedless to say, if the generator/sequence is used by multiple users,
>> 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;
> This is exactly what I want.
then this isn't safe.
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server