Float fileds + Lazaurs + Firebird

Mando · Post by **Mando** » 16.11.2012, 21:39

I've a table with a numeric (decial, float, double ...) field.
If I post a value divisible by 10 (10,20,...an so until 90), the liked TDBEdit shows 1,2,...9, in other cases, shows the actualy value 11,21,55,66...
If value has 1 or 2 decimals, the control rounds to iinteger (39,4->39 39,6->40->4).
if value >= 100 then it is showed in scientific notation, (100->1E2, 110>1,1
E2).
I know I can play with precission in the field definition, but I'm developing a Database administration utility, and I open the tables dinamically.
And I do not want to use the field display format. (TFloatField(Fields).DisplayFormat := '0.00'; )

Is there any way to solve that?

Regards

Post by **EgonHugeist** » 16.11.2012, 21:44

Mando,

this times ask on the Lazarus/FPC sites. That's not a Zeos issue. I remember some threads of people who had been running into the same issue. Thought that problem was introduced between LCL 0.93 and 1.01 but don't expect me for the right revision now.

Fields with double precision are displayed right i think..

Also do we use a TDataSet-descendant of the FPC TDataSet. All settings you wnat to have here are not solvable from Zeos side.

Mando · Post by **Mando** » 16.11.2012, 23:35

Ok, Thanks, but SQLdb has not that issue.

Regards.

Post by **EgonHugeist** » 16.11.2012, 23:52

Mando,

oh that's new for me. Becuse somewhere there was the thread i read in the past from. One thing you've to know. Zeos uses an Delphi & FPC compatible TDataSet. The SQLDB using the TBufferDataset. In the past we had some more trouble because our TDataSet is less maintained from the FPC side. Delphi don't show me this behavior. Maybe you can make me a little testcase again? Did you check that with FPC2.7.1?