At 03:08 PM 08-12-01 +0000, you wrote:

>I've put a TIBODatabase on the datamodule
>I've put a TIBOTransaction on the datamodule
> I've connected the IB_Connection to the TIBODatabase
>I've put a TIBOStoredProc on the datamodule
> I've set the Database property
> I've set the IB_Transaction to the TIBOTransaction

I just re-read this more carefully - sorry for not noticing before.

Take out the TIBOTransaction. TIBODatabase is like TDatabase - it is a container for a connection and a transaction. The TIBO datasets inherit the TDataset behaviour which includes being restricted to one and only one transaction per connection.

But the TIBO architecture has the capability to add more transactions. The TIBOTransaction encapsulates this "non-default" transaction. You can use such a transaction where you have a task that you want to isolate from the ibodatabase's default transaction context. The application context you have been describing does not seem to suggest that you want to do this.

With your datasets connected to the ibodatabase through the DatabaseName property, they are automatically placed in its transaction and connection context.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________