Using Databases in Interpreter

Comments

• gordk St.Catherines On. Canada.

  September 2004 edited 11:18PM

  Hi Willi
  which obp band or report component?
  where is query fr dialog or delphi form/dm ?
  
• wkuehnis

  September 2004 edited 11:18PM

  Hi,
  I now found the following: In the OnBeforePrint of a MasterData band I entered this code: (the qry's SQLtext works with a Variable "aktLayout" as Parameter)
  
  begin
  DialogForm.qry.Close;
  aktLayout := 1706;
  DialogForm.qry.Open;
  showband(child1);
  
  DialogForm.qry.Close;
  aktLayout := 1707;
  DialogForm.qry.Open;
  showband(child1);
  end
  
  On a childband I print a DB-Field of qry. This works, but I get only 2 times the value with aktLayout=1707.
  
  How can I do this correctly ?
  
  Thanks
  
• gordk St.Catherines On. Canada.

  September 2004 edited 11:18PM

  When using showband it will only appear the number of times you call show band.
  if you are trying to change the layout if a particular value is encountered in the md band and the Child belongs to mdBand or a band after
  then in obp of mdband
  if expression := true then
  change the connection of the mdband to which child you want and set the childbands' visible propertys accordingly.
  
  
• wkuehnis

  September 2004 edited 11:18PM

  gordk wrote:

  When using showband it will only appear the number of times you call show band.
  if you are trying to change the layout if a particular value is encountered in the md band and the Child belongs to mdBand or a band after
  then in obp of mdband
  if expression := true then
  change the connection of the mdband to which child you want and set the childbands' visible propertys accordingly.
  

  Thanks for your help,
  but of course it's OK, when it shows the child band only 2 times.
  But the first time it should show in the child the DB-Values with the parameter 1706, and the second time it should show the DB-Values of the parameter 1707. Both times it shows onyl the Values of parameter 1707
  That's my problem.
  
  
  Willi
• gordk St.Catherines On. Canada.

  September 2004 edited 11:18PM

  DialogForm.qry.Close;
  aktLayout := 1707;
  DialogForm.qry.Open;
  showband(child1);
  end
  
  it seems like the query is not being reset.
  this may be a problem when using the same query as the mdband is using.
  But try this
  give your query a name like query1 if you have more than 1 query on your dialog form.
  and try this
  query1.Close;
  aktLayout := 1707;
  query1.Open;
  showband(child1);
  end
  
  
  
• wkuehnis

  September 2004 edited 11:18PM

  gordk wrote:

  DialogForm.qry.Close;
  aktLayout := 1707;
  DialogForm.qry.Open;
  showband(child1);
  end
  
  it seems like the query is not being reset.
  this may be a problem when using the same query as the mdband is using.
  But try this
  give your query a name like query1 if you have more than 1 query on your dialog form.
  and try this
  query1.Close;
  aktLayout := 1707;
  query1.Open;
  showband(child1);
  end
  

  Thanks,
  but, I have only one query and this query has it's name.
  You can close a query, then set a parameter, then open the query, then it should show the new dataset, which I select with this "Where"-parameter
  ... and it has nothing to do with a "Reset", because it shows the values of the last parameter in all bands.
  
  Willi