DBGrid + Zeos do not show decimals

[Pere]

Sorry for my bad English.

With Firebird 2.1 + ZQuery the DBgrid do not show the decimals. (20.43 show 20).

I solved it manually adding (and formating) columns to DBGrid, but it is not a good solution if you use the same grid for different datasets.

There is another solution to solve it automatically?

Thanks,

[JD]

Put the format string in the DisplayFormat property of the DbGrid column in your form. That way you don't need to format the column in your code.

Be aware however that this format will apply to all datasets that are displayed using the DBGrid unless you change it manually again in your code. 

[lazguy]

It seems that Zeos have a bug when run on Linux. I have this problem also. If I am not wrong on Windows everything is Ok. (or if I am wrong) only the Delphi Version of Zeos is Ok. The problem is not only with DBGrid.

[garlar27]

I have the same decimals problem with TDbf and DBGrid. DBGrid in some cases show decimals in scientific format, some times shows 1 rounded decimal when it should show 2... I think the problem is in DBGrid.

[cpalx]

try to change  "," decimal to "." decimal. believe me that is the error.

[guidoaerts]

you can also change the displayformat property of the float-data-type fields  of an opened tztable or tzquery; that leaves your grid unaffected for other datasets

guido

[Pere]

I solved dinamically by:

  ZQuery1.Active:= True;

  with ZQuery1 do
  begin
   for i := 0 to FieldCount-1 do
   begin
    if Fields.FieldKind = fkData then if Fields.DataType =ftFloat then
     TFloatField(Fields).DisplayFormat := '0.00';
   end;
  end;

[cpalx]

good ...