Page 1 of 2

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

Posted: 26.01.2020, 09:22
by ribut
In ZeosLib 7.3 zero value display 00,000,000.00 in cell DbGrid
use Postgresql 10
Lazarus 2.0.6
Windows 7

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

Posted: 26.01.2020, 10:40
by marsupilami
Hello,

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

Jan

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

Posted: 17.02.2020, 23:17
by 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

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

Posted: 26.02.2020, 10:58
by ribut
Thank's a lot Jan
But a few problem see pict .jpg

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

Posted: 26.02.2020, 13:54
by marsupilami
Hello,

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

Jan

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

Posted: 26.02.2020, 14:18
by 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

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

Posted: 27.02.2020, 17:45
by marsupilami
I added a new comment about this to the Bugtracker. Best regards, Jan

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

Posted: 23.04.2020, 16:45
by 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

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

Posted: 03.05.2020, 18:29
by 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

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

Posted: 03.05.2020, 18:45
by ribut
After installing and running version svn 7.3-r6491, the problem still exists

regards

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

Posted: 04.05.2020, 17:11
by 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..

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

Posted: 05.05.2020, 05:40
by ribut
Hello Michael,
This a small demo app with a database script psotgresql

Thanks a lot

regards

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

Posted: 06.05.2020, 16:10
by 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?

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

Posted: 06.05.2020, 18:23
by 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

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

Posted: 08.05.2020, 21:39
by 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>