Create master/detail over another master/detail

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
madriz1989
Posts: 4
Joined: Wed 31 Jan 2018 19:12

Create master/detail over another master/detail

Post by madriz1989 » Mon 12 Feb 2018 20:49

Hi all,
I need to create master/detail of these tables:
Image

It has a master table "SIGEV_CARGA" and its detail "SIGEV_CARGA_DET", and at the same time the detail "SIGEV_CARGA_DET" is master of "SIGEV_BOLETA_PRODUCTOR" and the last one has a detail table "SIGEV_BOLETA_PRODUCTOR_DET"..

Is it possible to configure that with the property mastersource of TUniQuery?
How can I capture the ID_SIGEV_BOLETA_PRODUCTOR to save in its master SIGEV_CARGA_DET?

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: Create master/detail over another master/detail

Post by Stellar » Thu 15 Feb 2018 14:50

If you want to bind a detail dataset with several master datasets, then unfortunately there is no standard solution. TDataSet can be bound with only one master dataset using the TDataSet.MasterSource property, so it is not possible to bind a detail dataset with two master datasets. This functionality is not implemented in TDataSet, unfortunately we cannot influence this behavior.

madriz1989
Posts: 4
Joined: Wed 31 Jan 2018 19:12

Re: Create master/detail over another master/detail

Post by madriz1989 » Thu 15 Feb 2018 16:17

Ok, thanks @Stellar.. I'll do it separately.

Post Reply