FMTBCDField on a DBGrid displays huge numbers

[LacaK]

If you can prepare reproducible test unit , then we can test it on our versions ...

[benade]

If you can prepare reproducible test unit , then we can test it on our versions ...

I have included a test project.  Please note:
1. I have put everything in the testdb folder under c:
2. Again, this table will display the values correctly, because as I have mentioned is that this is the case when you recreate the table.
3. The DisplayFormat property does not work for the TFMTBCDFields.

I can, if needed, send you a link to download my complete project so far.  This will be a couple of Mb's though.

Thanks

[LacaK]

I do not have Firebird 2.5 installed, so I did test with Firebird 2.1.
I have create table and fill some data.
Result is IMO correct, see attached screenshot.
So I can not reproduce your problem.
(but I use FPC 2.7.1)

[benade]

I do not have Firebird 2.5 installed, so I did test with Firebird 2.1.
I have create table and fill some data.
Result is IMO correct, see attached screenshot.
So I can not reproduce your problem.
(but I use FPC 2.7.1)

I was just thinking that I should go back to using IBX, but my feeling is that sqldb will be better in the long run and the coding is really straight forward.  I tried to get FPC 2.6.4 going but can't get it right yet and I am searching the internet on the "how to" at the moment. So I will now focus on getting FPC 2.7.1 up and running and see what happens.

Thanks for your input.

[avra]

[...I will now focus on getting FPC 2.7.1 up and running and see what happens.

It's easy with FPCUP: https://bitbucket.org/reiniero/fpcup

[benade]

[...I will now focus on getting FPC 2.7.1 up and running and see what happens.

It's easy with FPCUP: https://bitbucket.org/reiniero/fpcup

Thanks, FPCUP worked just fine and the FMTBCDField displayed correctly with the FPC 2.7.1 version. Unfortunately I ran into trouble with a number of other issues like an active transaction that I can't close and I had to stop the Firebird service to get out of it.  Using Ctrl-spacebar will jump to the unit instead of showing me the list of available properties....  I assume this happens because Laz IDE 1.3 & FPC 2.7.1 is still in beta?

[avra]

FPCUP worked just fine and the FMTBCDField displayed correctly with the FPC 2.7.1 version. Unfortunately I ran into trouble with a number of other issues like an active transaction that I can't close and I had to stop the Firebird service to get out of it.  Using Ctrl-spacebar will jump to the unit instead of showing me the list of available properties....  I assume this happens because Laz IDE 1.3 & FPC 2.7.1 is still in beta?

It seams you have tried both LAZ and FPC from SVN. There is a big difference between SVN and beta. SVN is less stable, and from time to time it might even not work at all. If you play a little with FPCUP, you will be able to try LAZ 1.2 with FPC SVN (because it looks like FPC SVN fixed some of your problems, but maybe LAZ 1.3 introduced new ones).