Gordon,

<< Before the rollback or commit.  I pause the executable in the IDE to step
through the code.  While stepping through the code I complete the update to
the first table and then pause code execution - refresh my view of the data
in the EDBManager - and see the change that was made. >>

In that case there definitely is not a transaction in progress.  Are you
checking the TEDBDatabase.InTransaction property for the database during the
execution to make sure that the database is definitely in the middle of a
transaction ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
>
> In that case there definitely is not a transaction in progress.  Are you
> checking the TEDBDatabase.InTransaction property for the database during the
> execution to make sure that the database is definitely in the middle of a
> transaction ?

Yes.  I've sent you a sample project with a stripped down COM object and
a program module that shows the behavior I'm describing.

--
Gordon Turner
Mycroft Computing
http://www.mycroftcomputing.com

Gordon,

<< Yes.  I've sent you a sample project with a stripped down COM object and
a program module that shows the behavior I'm describing. >>

Okay, I finally figured out the problem.  You're calling FlushBuffers after
the updates, and EDB has a bug whereby it is ignoring the transaction when
FlushBuffers is being called.  The workaround until the next build is to not
call FlushBuffers if you're in the middle of a transaction.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
>
> Okay, I finally figured out the problem.  You're calling FlushBuffers after
> the updates, and EDB has a bug whereby it is ignoring the transaction when
> FlushBuffers is being called.  The workaround until the next build is to not
> call FlushBuffers if you're in the middle of a transaction.

OK.  I can live with that since I'm still in development.  I'm glad you
found the problem as I was beginning to think I was just a little crazy.
 (Although I probably am a little crazy anyway.)

--
Gordon Turner
Mycroft Computing
http://www.mycroftcomputing.com