FormatFloat d'ont work?

Comments

• Samuray Administrator

  November 2003 edited November 2003

  1.
  Don't use construction:
  if ([datam.cds."FLOATVAR"] <> null) then // wrong code
  
  use this code:
  if not FieldIsNull('datam.cds."FLOATVAR"') then // right code
  
  
  2. What decimal separator you use?
  
• S.Barco

  November 2003 edited November 2003

  -> 2. What decimal separator you use?
  The <span style='font-size:21pt;line-height:100%'>,</span> character, Configured in Operating System Internacional Settings.
  If I see the value in the database it's with comma too. Example 1000,12
  
  I try too whit #.##0,00, but I get the same bad result
  
  

  ---

  
  
  I d'ont know that exist FieldIsNull function in script mode.
  In FR2.4 Manual in the "List of functions" d'onts exist.
  Where can I get the last version manual or a renewed List of functions.
  
  Thanks Samuray
• Samuray Administrator

  November 2003 edited 3:17PM

  FieldIsNull new function (from 2.5)
  See undocumented.chm (in 2.51) for details.
  New documentation coming soon.
• S.Barco

  November 2003 edited 3:17PM

  About the formatfloat problem ...
  
  Can you give some clue?
  
  Thanks Samuray
• Samuray Administrator

  November 2003 edited 3:17PM

  Send me please your report .frf file. I want to look on this problem in current report ...
  
• S.Barco

  November 2003 edited 3:17PM

  RESOLVED!!!
  
  I used this new code:
  

  if ([datam.cds."FLOATVAR"] <> null) then
    [VARMEMO1] := FormatFloat('#,##0.00;;0.00', [datam.cds."FLOATVAR"]))
  else
    [VARMEMO1] := 'Null';
  

  
  I use VARMEMO1 as variable-scritp and this it's attached to a Memo Object.