On 15/04/13 13:20, Thomas Kellerer wrote: >... > Yes. To my knowledge the following DBMS support sequences (the way Oracle > does): > > ... > - Firebird (called "generators" there) Sorry to nit-pick Thomas, Firebird used to call them generators, but changed to the SQL standard naming convention of Sequences some time back. For now, however, the old name remains as a synonym for sequences. Same problems remain though, a rollback will lose a sequence value and you cannot guarantee no gaps. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- //www.freelists.org/webpage/oracle-l