Subject Re: [IBO] What's a connection for?
Author Lester Caine
jeffplata wrote:

> Oh, sorry. Should have been clearer. I am talking about IBObjects
> components, in fact.

You always need a Connection. It's what tells the components where to
connect. All the samples should have one, and it will point to the database.

The connection will have a 'default' transaction if nothing else is
added, and this will manage all the transaction stuff.

I normally add a transaction component for each connection ( you only
need a second connection if going to another database - perhaps on a
different machine or just a different database ). In doing that I have
control if I need it.

Most of the time ibobjects takes care of everything else for me on the
transaction front. Unless I have a set of queries that I want to group
together ( updating an order with several line items for example ) Then
I just StartTransaction - do the various bits and Commit or Rollback
depending if all items can be finished.

Lester Caine
L.S.Caine Electronic Services