As far as I know, Generators work outside the transactions. This means,
when you start a transaction, insert 2 records, so that the generator has
the value 7 and then rollback the transaction, the generator will keep
the value 7.

Guido

Dale Tabbert wrote:

> Hello,
>
> I am using IBO with ASTA. Yesterday afternoon I used DDL to create
> my tables, stored procs, generators, views etc. so I have a "clean"
> DB.
>
> I then entered two new "items" which consist of data across a few
> tables. The generator gave these items ID's 3 and 4. Late yesterday
> afternoon I added another item which recieved a value of 5. This
> morning I added yet another item which recieved a generated value of
> 6. A little while later, items "5" and "6" were gone as well as
> their corresponding detail information in other tables. I added
> another item which recieved a value of 7. (so the generator
> continued where it had left off)
>
> I am assuming that something rolled back a transaction (but not the
> value of the generator), but I'm not sure how or why. I have one
> IB_Transaction that is used by 9 different IBO datasets. (That is
> the way the ASTA server came). Is it possible that there is a buffer
> in Interbase that keeps uncommited transactions, and, if left
> uncommited are automatically rolled back?
>
> I should also mention that I use stored procedures exclusively to
> enter data into the system. I use SP's and Views (mostly SP's) to
> retrieve data.
>
> Any insight would/will be greatly appreciated.
>
> Thanks
>
> Dale