[Solved] Difference between table definition and screen

[madref]

I have a table tbl_Seizoenen which is defined as

Code: SQL  [Select][+][-]

1. CREATE TABLE "tbl_Seizoenen" (Sei_ID Word PRIMARY KEY ASC, SEI_Periode VARCHAR(9),
2. Sei_Van Word, Sei_Tot Word, Sei_Selected BOOLEAN, Sei_KMV FLOAT, Sei_Letter CHAR)

And is filled like in attachment 1.
But when I make a form and try to fill it or change it, it is shown as in attachment 2.

How is that possible?
And can this be corrected?

[andresayang]

Hi,

???

Can you post the code you are using to try to "fiil or change it" ?
Wee will have a better idea on what is going on.

Cheers

[Thaddy]

0.3 float can't be expressed in binary. Needs rounding. Use a currency type or a BCD or round. Some sql versions do it correctly, though

[madref]

I am using SQLite....

How to fix this problem?


@andresayang
It's a standard TDBEdit that i use. Which is connected to a DataSource

[Lutz Mändle]

Set the property DisplayFormat of the TField component to '0.00'. If your dataset component is a TSQLQuery descendant do this in the AfterOpen event:

Code: Pascal  [Select][+][-]

1. TNumericField(DataSet.FieldByName('Sei_KMV')).DisplayFormat:='0.00';
2.  

The property DisplayFormat is only available for TNumericField descendants.

[madref]

Thanks....
This works.