DBXQuery

Comments

• d_kooker

  September 2004 edited 2:18AM

  I did some followup checking and I have the same problem with bde queries too. Is it still possible to do master/detail reports within FASTREPORT as was in version 2 where the queries are defined in the form rather then using datasets defined in delphi?
• d_kooker

  September 2004 edited 2:18AM

  I seem to be talking to myself here- No one has offered any help..., but I've figured out the following workaround, I've placed the following code in the Masteronbeforeprint procedure. Strangly it mostly works without the active/inactive but sometimes doesn't. From what I can tell, parameters on the detail query are just being set at the beginning in fr3 and are not being reset for each master (Bug??). This stuff all worked ok in fr2.
  
  detail.active := False;
  detail.params[0].value :=vartostr(<master."WORKSPACEID">);
  detail.params[1].value :=vartostr(<master."BASEID">);
  detail.active := True;
  
• AlexTZ

  September 2004 edited 2:18AM

  Just set the DetailQuery.Master property to MasterQuery. DetailQuery Params should have names same as MasterQuery master fields.
• d_kooker

  September 2004 edited 2:18AM

  Thank you so much for your help. It worked like a charm. I've been stuck trying to get this to function for weeks.
• d_kooker

  September 2004 edited 2:18AM

  I spoke too soon - It works great for master/detail, but when I do master/detail/subdetail I get an "operation can not be performed on a closed dataset" when it goes to the second master record.