[SOLVED] DBGrid - How to Format Two Decimal Places to the Right
lazarus / 16-Databases

----------------------------------------------------------------------
guest48180 · 2018-08-13 18:05

In the SQLite3 db, the field holds entries of 286.53 and 225.50. When
I call for the data and place these fields in DBGrid, I get
286.52999999999997 and 225.5. The field is of type REAL.

How can I force the DBGrid disp0lay to show 286.53 and 225.50
respectively?

----------------------------------------------------------------------
denver · 2018-08-13 18:09

Try

i := 0  // The First Column
i := 1 // The Second Column

DBGrid1.Columns.Items[ i ].DisplayFormat := ' #.00' ;

----------------------------------------------------------------------
guest48180 · 2018-08-13 18:13

Works like a charm. Thanks, denver.