DBGrid.Displayformat
lazarus / 16-Databases

----------------------------------------------------------------------
fengyun · 2014-10-27 05:44

Value is 3.2465
Use DBGrid.Displayformat:=0.00,
value yet display 3.2465

Why ? Why ? Why ?

----------------------------------------------------------------------
exdatis · 2014-10-27 06:03

Use Query;
sqlQuery.Fields[index].DisplayFormat:= '#0.00'

TDateField(sqlQuery.Fields[index]).DisplayFormat:= 'dd.MM.yyyy';

the same for: DisplayLabel, DisplayWith etc.

p.s. You can use Object inspector->Fields->properties

----------------------------------------------------------------------
fengyun · 2014-10-27 06:34

Thank you

----------------------------------------------------------------------
fengyun · 2014-10-27 07:36

The reason is database.
sqlite not ok,
Access is OK