Re: Detail not updated
From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 03/24/04
- Next message: Brian Bushay TeamB: "Re: getting list of SQL Sever and list of database for particular server"
- Previous message: crystal: "Re: XML file to ADO table"
- In reply to: Joao Kho: "Detail not updated"
- Next in thread: Joao Kho: "Re: Detail not updated"
- Reply: Joao Kho: "Re: Detail not updated"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 23 Mar 2004 20:39:36 -0600
>I have some testing using batch updates and lock-type ltBatchOptimistic.
>
>I using Header and Detail (2 table that linked with [header_id]).
>The detail using DBGrid to display. But I found the detail not
>updates(save), just updated/save Header record???
You need a separate updateBatch for each dataset.
If you have the detail linked with a parameterized query then you will loose the
detail updates when you change the master record if you have not called
updateBatch first
-- Brian Bushay (TeamB) Bbushay@NMPLS.com
- Next message: Brian Bushay TeamB: "Re: getting list of SQL Sever and list of database for particular server"
- Previous message: crystal: "Re: XML file to ADO table"
- In reply to: Joao Kho: "Detail not updated"
- Next in thread: Joao Kho: "Re: Detail not updated"
- Reply: Joao Kho: "Re: Detail not updated"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
