karolbieniaszewski wrote:

>> Are there real situations when you might need to know a generator value
>> > without using it in a transaction?
>> >
> Generator can be used for some other conditions
> 1. as database settings
> 2. as replacement for events - you can inc generator value in some conditions eg. some client interest tables are modified.
> Client read in some interval generator value if is different then previous then data should be refreshed
> 3 ..
> 4..
>
> i suppose more examples can other users show

But in those examples you still need a connection and a default transaction to
do any reading makes sense. I don't see any reason that there would not
generally be an open connection without some transaction being used? At least
not the way I normally work ...

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php