Subject | Re: [IBO] Paradox to IB/IBO |
---|---|
Author | Helen Borrie |
Post date | 2004-02-27T21:09:40Z |
At 10:39 AM 27/02/2004 -0500, you wrote:
Autocommit:
do stuff, request to post, (autostart transaction if not started,
commitretaining)
do stuff, post (post & commitretaining)
do stuff, post (post & commitretaining)
....
Explicit
autocommit false or true
transaction.starttransaction (temp. disables autocommit if true)
transaction.starttransaction
do stuff, post
do stuff, post
do stuff, post
...
...
transaction.commit
You actually need to intervene in the "autocommit cycle" from time to time,
following an autocommit (i.e. Post) with
if transaction.Started then
transaction.Commit;
So, breaking into the cycle looks like this:
do stuff, request to post, (autostart transaction if not started),
commitretaining
do stuff, post (post & commitretaining)
do stuff, post (post & commitretaining)
....
if transaction.Started then
transaction.Commit;
do stuff, request to post, (autostart transaction if not started),
commitretaining
do stuff, post (post & commitretaining)
do stuff, post (post & commitretaining)
....
if transaction.Started then
transaction.Commit;
....
Helen
>Helen,Autocommit and explicit control are two sides of the coin:
>
>Thanks for your thoughtful reply. It is very helpful.
>
>To 'take explicit control of the AutoCommit cycle...
Autocommit:
do stuff, request to post, (autostart transaction if not started,
commitretaining)
do stuff, post (post & commitretaining)
do stuff, post (post & commitretaining)
....
Explicit
autocommit false or true
transaction.starttransaction (temp. disables autocommit if true)
transaction.starttransaction
do stuff, post
do stuff, post
do stuff, post
...
...
transaction.commit
>'as you recommend, do IIsolation level isn't part of Autocommit.
>just call commit at
>logical points (after posting or execSQL) while leaving ReadCommitted as the
>isolation level
>and Autocommit = True?
You actually need to intervene in the "autocommit cycle" from time to time,
following an autocommit (i.e. Post) with
if transaction.Started then
transaction.Commit;
So, breaking into the cycle looks like this:
do stuff, request to post, (autostart transaction if not started),
commitretaining
do stuff, post (post & commitretaining)
do stuff, post (post & commitretaining)
....
if transaction.Started then
transaction.Commit;
do stuff, request to post, (autostart transaction if not started),
commitretaining
do stuff, post (post & commitretaining)
do stuff, post (post & commitretaining)
....
if transaction.Started then
transaction.Commit;
....
>PS. Does 'Reply Group' work?Apparently not. This came through to me as a private message.
Helen