Subject | Re: [IBO] TIBOTransaction |
---|---|
Author | Robert martin |
Post date | 2006-11-05T20:51:04Z |
Hi Jason
I have read the help somewhat carefully. Thanks you are right I needed
to ! I think I now have a better grasp over what is happening, my trap
was that I was using explicit transactions in a number of places and the
Started property showed as true while they were running. However in one
piece of code it did not and this crashed with a parameter missing
error. The error stopped when I set Started := True. So I thought it
mysterious :)
However when I say my code, I actually mean a co workers code. So there
is probably some other issue causing the problem. Thanks for your time.
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd
Jason Wharton wrote:
I have read the help somewhat carefully. Thanks you are right I needed
to ! I think I now have a better grasp over what is happening, my trap
was that I was using explicit transactions in a number of places and the
Started property showed as true while they were running. However in one
piece of code it did not and this crashed with a parameter missing
error. The error stopped when I set Started := True. So I thought it
mysterious :)
However when I say my code, I actually mean a co workers code. So there
is probably some other issue causing the problem. Thanks for your time.
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd
Jason Wharton wrote:
> Rob,
>
> It is very clearly documented that IBO distinguishes between three
> transaction aspects, each having their own methods and status indicators.
>
> Implicit: StartTransaction, InTransaction
> Logical: Activate, TransactionStatus
> Physical: Start, Started
>
> You are mixing the implicit transaction mechanisms with the physical
> transaction mechanisms. Each of these three aspects of transaction do
> overlap some, but each have their own distinct and specific roles and
> behaviors.
>
> Some of these, like Activate and Start, you don't ever have to call, unless
> for some reason you need or want to. Activate tells IBO that there is an
> update of some kind to the data that needs to be committed. Normally this
> happens whenever you post a dataset insert, update or delete. It will also
> happen after execution of a statement of stDML or stDDL statement type.
> Start simply makes sure there is a physical handle present on the client,
> which means there is a physical transaction in progress on the server.
> Calling StartTransaction doesn't immediately ensure that a physical
> transaction is present, though I believe there is a good argument in favor
> having it do so. The reason I don't currently have it do so is because IBO
> makes it 100% automatic to start a physical transaction whenever necessary.
>
> You would do well to read very carefully in the help file where this is all
> explained in much more detail.
>
> Regards,
> Jason Wharton
>
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On Behalf
> Of Robert martin
> Sent: Thursday, November 02, 2006 5:47 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] TIBOTransaction
>
>
> Hi
>
> I am seeing problems in an application where
> IBOTransaction.StartTransaction does not start a transaction. If I
> check immediately after this call IBOTransaction.Started = false. If I
> replace IBOTransaction.StartTransaction with IBOTransaction.Started =
> true then the transaction does start. The IBOTransaction is NOT the
> interal transaction. I have tried tracing through the source but just
> cant see it.
>
> Any suggestions would be greatly appreciated :)
>
> --
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>
>