🚀 go-pugleaf

Hi everyone.

I'm experiencing some acute problems with the Transaction commands in the
ADOExpress
components.

Here's the deal:
I begin a transaction with the ADOConnection component:
  FrmMain->DBConnection->BeginTrans();

Then I do a function call to another procedure that executes queries through
an ADOQuery com-
ponent.  Those ADOQuery components has DBConnection as their connection (in
other words there is only
one (1) connection component in the whole program).
Inside the called function at least 3 to 4 insert statements are done to the
same table.  When the function
returns I do a commit:   FrmMain->DBConnection->CommitTrans();

When I go and look at the table with the 3 inserted rows only the last row
is in actual fact there.
The table has an auto-incremented field as primary key.  So the table looks
like this:

ID  Description
...
99  First visit                           <-- start of Transaction
103 Interest calculated.           <-- after the commit

From the above it is clear that 4 inserts where made but the first 3 were
never committed.

I'm using BCB5 Enterprise with Update pack 1.  Also an ADOExpress update is
in place.
The ADOConnection component has no Attributes,
ConnectionOptions = coConnectUnspecified
Provider = SQLOLEDB.1
CursorLocation = clUseClient
and I'm working to an SQLServer7/MSDE database.

Thanks in advance.
Chris

-----------------------------------------------------------
Chris Buys (B.Sc. (Comp.Sci.) Stell.)
Development

HAS Software (Pty) Ltd
MedAd2000
Tel:       +27 (0)21 553 2402
Fax:      +27 (0)21 553 3323
E-mail:  mailto:chris@h-a-s.co.za
Web:    www.h-a-s.co.za