The problem with generators is simply that they are outside of transaction
control.
When a sequence number is generated, that is it. The generation cannot be
rolled back if the transaction itself is rolled back.
This leads to the gaps you mention.

I work with Oracle databases, and I have things called sequences which are
exactly the same as Interbase generators.
These too are outside transaction control, so if a transaction rolls back,
there will be a 'lost' number from the sequence.

The answer is to use Jason's tech article to ensure that there are no lost
sequence numbers, or, simply ignore the fact that a sequence number has gone
'missing'.

HTH (slightly ?)

Regrads,
Norman.

PS. Why can't I ever type 'regrads' correctly :o)


-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar@...
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------


-----Original Message-----
From: Ales Kahanek [mailto:ales.kahanek@...]
Sent: Monday, December 03, 2001 1:39 PM
To: 'IBObjects@yahoogroups.com'
Subject: RE: [IBO] generator on post


Lester wrote:

>I only use GeneratorLink. This does indead use up a number
>when creating the 'blank', which can not be 'returned' if
>you then cancel the record. I build the record before
>calling the insert, so only call insert IF I want to add the
>record.

It sounds interesting, but I cannot imagine, how you build the record before
calling the insert. What about if you have IB_Edits on the form and the user
clicks on the update bar to insert a new record. Then the generator is fired
and after canceling the number is lost and a gape occures. What can we do
with this? I?ve read the Jason?s article about auditable series, but the
solution seems not to be too streightforward.

Ales


___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

This email is intended only for the use of the addressees named above and
may be confidential or legally privileged. If you are not an addressee you
must not read it and must not use any information contained in it, nor copy
it, nor inform any person other than Lynx Financial Systems or the
addressees of its existence or contents. If you have received this email
and are not a named addressee, please delete it and notify the Lynx
Financial Systems IT Department on 0113 2892990.