> No, I think you don't understand what a transaction is/does. Everything in
> IB/Fb happens inside a transaction. So the SELECT statement gets prepared
> the first time you open the dataset. The transaction has to start before
> Prepare can happen, and IBO takes care of that if you are not controlling
> transactions explicitly.

No, I do understand what a transaction is. I've been using IB/IBX for
about two years now. "Here a transaction, there a transaction,
everywhere a transaction...'ol McDonald has a database...eee iiii eeee
iiii ooooh" :0)

In IBX, you MUST (or at least I always thought so) start an explicit
transaction. That is what I was wondering about with IBO.

> "Edit" is a client-side thing. When you call Edit on a dataset, you're
> asking the component to set things up so that the current row in the buffer
> is going to be (or likely to be) updated. Edit does nothing on the server
> at all. But any changes you are going to do are going to be in the
> *current* transaction context. So you see that the idea that "IBO starts a
> Transaction automatically when you edit data in a IBODataaset" is a
> mistake. (IBO isn't different to IBX or the BDE in this respect.)

OK, that is what I was wondering about. I must have been thinking about
a "Logical" transaction then?

>
>
>>Is this list archived somewhere (like fasttextsearch.com)?
>
>
> Yes: at news://news.atkin.com. The on-line FAQ is also a Firebird
> database of about 1800 IBO list topics distilled into short Q & A articles,
> with keyword searching (yah, I wrote it...)

Thank you.

>
>>BTW, Helen, you're everywhere!
>
>
> Tell me about it. :(
>

Well, I for one, am grateful... :)


--

Warm Regards,

Lee