Re: 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.

If you are using a parameter in the detail SQL that gets its values from the
MasterDataset Delphi will update this parameter and requery the detail when ever
the master record changes including when it is posted.
If you use this method of mater detail linking you need to updateBatch for the
detail table first then the master table and do this every time detail for a
master record are edited.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Quantcast