TfrPictureView / Band OnBeforePrint

Comments

• basswar

  January 2004 edited 3:51AM

  Hi!
  
  Use the FIELDISNULL internal function for testing the field for null value.
  
  Regards:Alex
• mrissmann

  February 2004 edited 3:51AM

  The function doesn't appear to work. It always evaluates to true (even though it is not)
  
  
  begin
  if (FieldIsNull([taDocumentPrintouts."Signature"])) and
  (FieldIsNull([taDocumentPrintouts."Signature2"])) and
  (FieldIsNull([taDocumentPrintouts."Signature3"]))
  then
  Child1.Visible := False
  else
  Child1.Visible := True
  end
  
  -Markus
• basswar

  February 2004 edited 3:51AM

  Some correction. Gord wrote in the Yahoo mail list not too much time ago.
  
  if [(FIELDISNULL('CustomerData.Customers."Contact"'))]then
  
  in 2.51 you'll find it in the expression builder under dabase functions.
  note the ' ' around the module.table.fieldname
  IIRC the expression builder won't add them
  
  Try this.
  
  Regards:Alex
• mrissmann

  February 2004 edited 3:51AM

  Great! That works!!!
  
  Thanks much,
  
  Markus