DB2 OLEDB Provider


I am trying to debug a simple master detail form which uses TADOQuery and TADOConnection to display and update data store in a AS400/DB2 v. 5.x. I would like to use a client cursor and to perform a Batch Update (lock type ilBatchOptimistic). The form is set up using data aware components and there is a save button which does something like this:
<p>
DBConn.BeginTrans;
HeaderQry.UpdateBatch
DetailQry.UpdateBatch
DBConn.CommitTrans
<p>
The problem I have is that the changes to the detail query are dropped regarless of the order I call their respective UpdateBatch methods. I think the problem has to do with the driver included with client access but I am not sure how to fix it. Can someone give any ideas? I have written similar code for Oracle 8i, 9i and 10g and I had no problems.

Thanks in advance for your help.


.

Quantcast