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