Subject RE: [IBO] Explicit transaction and FK Violation
Author Nico Callewaert
Thanks Jason,

Nico Callewaert
-----Oorspronkelijk bericht-----
Van: Jason Wharton [mailto:jwharton@...]
Verzonden: zaterdag 17 februari 2001 20:39
Onderwerp: Re: [IBO] Explicit transaction and FK Violation

Calling StartTransaction is only necessary when you want to take
control of transactions. This really only has to do with the logical
unit of
work aspect and not necessarily the physical aspect (meaning whether
is a transaction handle brought to the client).

Where StartTransaction comes in handy is if in most circumstances
the transaction in AutoCommit mode (which means after each dataset
there is a SavePoint generated) and you want to suspend that
behavior and
allow multiple posts to be held within a single logical unit of
work. This
is the main use of calling StartTransaction.

The InTransaction property is only true when StartTransaction has
called. These two are tied together.

Calling Commit does not Unprepare statements. If you know you are
not going
to be needing a statement any longer calling Unprepare is a very
good thing
to do for both the server and the client.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Nico Callewaert" <nico.callewaert@...>
To: <>
Sent: Saturday, February 17, 2001 11:53 AM
Subject: RE: [IBO] Explicit transaction and FK Violation


Do you have to call "StartTransaction", or does IBO this for you ?
Because I never call this method and everything seems to work fine.
you could explain me the advantage of this ? And is it necessary to
"Unprepare" for a query, or is a hard "Commit" enough ?

Many thanks,
Kind regards,

Nico Callewaert

------------------------ Yahoo! Groups
Sponsor ---------------------~-~>
eGroups is now Yahoo! Groups
Click here for more details

Stamp powered by

[Non-text portions of this message have been removed]