Lazarus 0.9.28.2 & Firebird 2.1.3 & Zeos 6.6.6 decimal problem
lazarus / 16-Databases

----------------------------------------------------------------------
christensen · 2010-12-11 19:54

Hi guys,

I have a problem displaying decimals in the DBgrid.
in the Firebird i have a 'decimal' field type(DECIMAL(15,2) ) if i
insert a number like: 1.5 in the IBexpert will be displayed as 1.50
but in DBgrid appear 2.
what i've noticed.... below 1.4 will appear to 1 and above 1.5 will be
2.

there is a solution for this problem?besides changing db component?

Thanks

----------------------------------------------------------------------
joseme · 2010-12-16 14:37

Hi christensen,
look at http://www.delphipages.com/forum/showthread.php?t=15359 and
http://www.lazarus.freepascal.org/index.php?topic=8562.0, these may
help

----------------------------------------------------------------------
christensen · 2010-12-26 18:36

thanks, i've solved like this:

Code: [Select]procedure TForm1.Button1Click(Sender: TObject);
begin
if (zQuery1.FieldByName('another').DataType = ftFloat)  then
              TNumericField
(zQuery1.FieldByName('another')).DisplayFormat:= '###,###.00'; 
end;