Setting Master-Detail relationship from designer

Dave F

How do I set a master/detail relationship from inside the designer?

gpi

Set Master property for detail query, use param names in the detail query as field names in the master dataset

Dave F

Where? On the Data tab? A short example would be great.

gpi wrote: »

Set Master property for detail query, use param names in the detail query as field names in the master dataset

Dave F

Actually, I'm trying to do this from the Code tab, with something like this:

begin
    GetDataSet('Product').MasterSource:=GetDataSet('Typ_prod').DataSet;                                                                                                                                                                                                                                                                                      
end.

But that doesn't work.

gpi wrote: »

Set Master property for detail query, use param names in the detail query as field names in the master dataset

gpi

See a sample for FRDemo in the attach

Dave F

But we're using dBase tables with TTable, not ADO.

gpi wrote: »

See a sample for FRDemo in the attach

gpi

See a sample for FRDemo in the attach (TfrxBDETable have same behavior like TfrxADOTable)

Dave F

This is the same demo, with TfrxADOTable.

gpi wrote: »

See a sample for FRDemo in the attach (TfrxBDETable have same behavior like TfrxADOTable)

gpi

There are no any differences between TfrxADOTable and TfrxBDETable usage

Dave F

I'd like to be able to use the designer to establish a master-detail relationship between a pair of TfrxBDETables. A TfrxADOTable can easily be dropped on the TfrxDesigner.CodePanel by using the palette. But TfrxBDETable is not available to be dropped. Can I get CodePanel to take a TfrxBDETable via code?

gpi wrote: »

There are no any differences between TfrxADOTable and TfrxBDETable usage

Dave F

Sorry, I meant I'm trying to add a TfrxBDETable to the DataTree. Something like "myBDETable.Parent:=TfrxDesignerForm(frxReport1.Designer).DataTree.DataPn;".

Dave F wrote: »

I'd like to be able to use the designer to establish a master-detail relationship between a pair of TfrxBDETables. A TfrxADOTable can easily be dropped on the TfrxDesigner.CodePanel by using the palette. But TfrxBDETable is not available to be dropped. Can I get CodePanel to take a TfrxBDETable via code?

Dave F wrote: »

There are no any differences between TfrxADOTable and TfrxBDETable usage

Dave F

Ok, this is a bit weird. Don't know why I didn't notice this before. The reason I've been asking about this is because I don't see the frxBDE components on the palette for me to add. Please check the attached screenshot named "NoBDE.png".

Dave F wrote: »

Sorry, I meant I'm trying to add a TfrxBDETable to the DataTree. Something like "myBDETable.Parent:=TfrxDesignerForm(frxReport1.Designer).DataTree.DataPn;".

Dave F wrote: »

I'd like to be able to use the designer to establish a master-detail relationship between a pair of TfrxBDETables. A TfrxADOTable can easily be dropped on the TfrxDesigner.CodePanel by using the palette. But TfrxBDETable is not available to be dropped. Can I get CodePanel to take a TfrxBDETable via code?

Dave F wrote: »

There are no any differences between TfrxADOTable and TfrxBDETable usage

gpi

Add TfrxBDEComponents to your project