Setting Master-Detail relationship from designer

Comments

• gpi

  November 2017 edited 1:46PM

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

  November 2017 edited 1:46PM

  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

  November 2017 edited 1:46PM

  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

  November 2017 edited 1:46PM

  See a sample for FRDemo in the attach

  test1.fr3 4.4K
• Dave F

  November 2017 edited 1:46PM

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

  gpi wrote: »

  See a sample for FRDemo in the attach
• gpi

  November 2017 edited 1:46PM

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

  test2.fr3 3.9K
• Dave F

  November 2017 edited 1:46PM

  This is the same demo, with TfrxADOTable.
  

  gpi wrote: »

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

  November 2017 edited 1:46PM

  There are no any differences between TfrxADOTable and TfrxBDETable usage
• Dave F

  November 2017 edited 1:46PM

  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

  November 2017 edited 1:46PM

  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

  November 2017 edited 1:46PM

  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

  YesBDE.png 95K

  NoBDE.png 53.8K
• gpi

  November 2017 edited 1:46PM

  Add TfrxBDEComponents to your project