Setting Master-Detail relationship from designer

Comments

• gpi

  November 2017 edited 12:45PM

  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 12:45PM

  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 12:45PM

  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 12:45PM

  See a sample for FRDemo in the attach
• Dave F

  November 2017 edited 12:45PM

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

  gpi wrote: »

  See a sample for FRDemo in the attach
• gpi

  November 2017 edited 12:45PM

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

  November 2017 edited 12:45PM

  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 12:45PM

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

  November 2017 edited 12:45PM

  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 12:45PM

  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 12:45PM

  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

  November 2017 edited 12:45PM

  Add TfrxBDEComponents to your project