As for generators, they are not effected by a rollback because they are
outside of transaction control. Were it not so they would not be of any
special value when producing unique identifiers in a multi-user environment.

As for the transaction behavior with ASTA. If you are using an explicit
TIB_Transaction object you need to ensure that you are committing it so that
changes are saved. If not then chances are things are getting rolled back as
this is also InterBase's behavior if there is ever ambiguity about
uncommitted changes. For example, a lost connection results in all
work-in-progress being rolled back.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Dale Tabbert" <dale@...>
To: <IBObjects@egroups.com>
Sent: Friday, January 12, 2001 2:03 PM
Subject: [IBO] IB_Transaction


> 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
>
>
>
>