Fetch data on ClientDataSet Master-Detail relation

Fetch data on ClientDataSet Master-Detail relation

Post by Ang Lik Hu » Sun, 01 Feb 2004 13:08:17

Hi there,

I have an master-detail relationship table, where one master link to three
detail using simpledataset. And i need to regenerate the transaction record
the master file.

Where is the best place to trigger it ? I found that i cound't do in
dataset's afterscroll and datasource's datachange cuz it will trigger while
i open my master file record.

Thanks for the help !!

magic ang

1. How can I filter a Master ClientDataSet from the Detail ClientDataset field values ?

2. ClientDataSets in Master-Detail question

I have a Master-Detail relationship based on three tables.

I am very well aware that I can setup a query in the detail table and use
parameters to keep the detail in sync with the master.

However, what is the best practice for when a detail is derived from two
master tables such that I would, in essense, need to pass two parameters,
one from one master and another from the second master? Granted, I can set
filters based on the second parameter, but my final goal is to use
ClientDataSets to reconcile the records back to the SQL database.

Is this possible, or do I need to manage this in multiple steps?


Mark A. Deal
Document & Data Solutions, LLC
Time Matters AIC
HotDocs Certified Consultant
GhostFill Certified Consultant

3. How to simulate 'DISTINCT' in ClientDataSet master-detail connections tree?


5. Master-Detail ClientDataSet update sequence

6. ClientDataSet Master-Detail with Inner Join


8. Challenge: Master-Detail ClientDataSets from Stored Procs...

9. datagridview is not updating in master-detail relation

10. master-detail relation with object binding

11. 3 levels Master - Detail relation in data table

12. how to improve speed of fetching record in Master-Detail Relationship?

13. "Master-Detail" binding though "m-m relation" tables, 3 DataGridVi

14. master-detail relation with object binding

15. How can delete a record in a master-detail relation