Subject Re: [IBO] Paradox to IB/IBO
Author Helen Borrie
At 10:39 AM 27/02/2004 -0500, you wrote:
>Helen,
>
>Thanks for your thoughtful reply. It is very helpful.
>
>To 'take explicit control of the AutoCommit cycle...

Autocommit and explicit control are two sides of the coin:

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 I
>just call commit at
>logical points (after posting or execSQL) while leaving ReadCommitted as the
>isolation level
>and Autocommit = True?

Isolation level isn't part of Autocommit.

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