In Lazarus 2.0.6 DBGrid display format ,0.00;-,0.00;

[ribut]

In ZeosLib 7.3 zero value display 00,000,000.00 in cell DbGrid
use Postgresql 10
Lazarus 2.0.6
Windows 7

[marsupilami]

Hello,

I created a ticket on the bug tracker for this: https://sourceforge.net/p/zeoslib/tickets/408/
Best regards,

Jan

[marsupilami]

Hello,

Egonhugeist has added a possible fix for this. Could you please check wether the latest SVN revision still has that bug?

Best regards,

Jan

[ribut]

Thank's a lot Jan
But a few problem see pict .jpg

[marsupilami]

Hello,

I am sorry, but I cannot get the problem. For me everything looks good?
Best regards,

Jan

[ribut]

Sorry for my incomplete explanation, I mean that zeos 7.3 does not display the value of 0 in the cell as the value of 0 displays in the cell when using zeos 7.2, it looks like the attached picture.
cell format, 0.00; -, 0.00; after the last semicolon containing spaces it should not display the value 0.00 in the figure shown when using zeos 7.2

sorry i use google translate

[marsupilami]

I added a new comment about this to the Bugtracker. Best regards, Jan

[marsupilami]

Hello, one more questions: Which datatype do you use for your fields? Are they floats? Or are they NUMERIC(x, y)? Does the problem still exist?

Best regards, Jan

[ribut]

I'am Sorry, for the late replay

Datatype numeric(22,4)

I will try again with the latest svn 7.3 version, as soon as possible

regards

[ribut]

After installing and running version svn 7.3-r6491, the problem still exists

regards

[EgonHugeist]

Hello ribut,
could you please make a small demo application, with a create-skript, some expected values etc. I'm not able to reproduce the issue on my system. I can help quickly if you can provide a template app..

[ribut]

Hello Michael,
This a small demo app with a database script psotgresql

Thanks a lot

regards

[EgonHugeist]

Hello ribut,

first i did not understand the proplem but testing it with delphi... your testcase works with all knonw delphi compilers we support except fpc..
There is a bug in FormatBCD() of FPC (we replaced CompareBCD(buggy), DoubleToBCD(buggy), CurrencyToBCD(slow) already )

I must admit replacing the function FormatBCD() is a huge job. It's not a Zeos a zeos issue it's a fpc bug. What do you think? What should we do?

[ribut]

I do not understand and can not give advice on what to do, if indeed this is a bug on fpc, I should temporarily use zeos 7.2 until the bug on fpc is resolved, but I will try to continue every release of the latest zeos 7.3 svn.

Alright, thanks a lot Michael

regards

[aehimself]

<Completely OFF>
I do ENVY those great-looking DBGrid components! I wish Embardero would invest in making their components look a little bit more... modern.
I had to write a DBGrid descendant to fix some scrolling / painting issues and it makes me so sad that a paid product is ages in front of something freely available...
</Completely OFF>