Master Detail tables with CacheUpdate

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 3
Joined: Sun 06 Apr 2008 18:42
Location: Montréal

Master Detail tables with CacheUpdate

Post by Trianon » Sun 06 Apr 2008 19:19

Hi Everybody,
I would like to know, what are the best practices in order to implemante a master-detail relationship with SDAC for Delphi 2006 using the CacheUpdate property.

- TMSQuery or TMSTable
- Create the Mastertable;
- Pass the PK to the detail table
- How to apply the changes.

Thank you.

Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 08 Apr 2008 13:32

Please take a look at the "Working with master/detail relationships" topic in SDAC help. It also describes the case in which CachedUpdates can be used with master/detail in SDAC.

Post Reply