Home Datapipelines

How to link two datapipeline as master/detail relationship?

edited September 2002 in Datapipelines
and How to Set the MasterFieldlinks property

at run time?

thank you .


  • edited September 2002
    Are you using master field links to perform master detail linking as it is
    done in DADE by using a single query for all detail records, instead of
    letting Delphi fire a detail query every time the master record changes?
    Here is a demo of this approach:


    Tech Tip: Define Master/Detail DataPipeline Links in Code

    Defining a Master/Detail relationship for a DataPipeline
    requires that the detail pipeline have the
    following properties defined:

    1. MasterDataPipeline

    2. MasterFieldLinks

    At Delphi design-time you can use the object inspector
    and the DataPipeline's FieldLinks editor to define
    the master/detail relationship.

    The following example illustrates how to define the
    master/detail relationship dynamically at run-time.

    lFieldLink: TppMasterFieldLink;


    {define the master/detail pipeline relationship}
    plDetail.MasterDataPipeline := plMaster;

    {create a new field link }
    lFieldLink := TppMasterFieldLink.Create(nil);

    lFieldLink.Parent := plDetail;

    {assign the detail field name}
    lFieldLink.DetailFieldName := 'CustNo';

    {assign the master field name}
    lFieldLink.MasterFieldName := 'CustNo';


    Note: The DataPipeline linking requires the records in the detail dataset to
    be ordered by the linking fields. In the above example, the detail data must
    be ordered by CustNo.

    Tech Support mailto:support@digital-metaphors.com
    Digital Metaphors http://www.digital-metaphors.com


    Jim Bennett
    Digital Metaphors

This discussion has been closed.