decimals after . exmpl 0.2 must read .20

[Guest_imported]

I've got a problem

I use a dbase database in the database desktop I can see the number for example

2.00

but in delphi edits and grids it rounds it off to

2

or 2.30 becomes 2.3

I use delphi 3 can someone help? PLEASE!

email me a qobcc@yahoo.com


thanx
hennie

 

[StevenK]

In order for this to be achieved you can select the Field against the Dataset (TTable or TQuery component) and make use of the DisplayFormat property against the field.
Set the property to be something like '0.00' (2 decimal places) or '0.000' (3 decimal places).
When you display the field in data aware components (DBEdit or DBGrid for example) the field entry should be formatted as required.
Steve

 

[Guest_imported]

Thanx, could you please post me sample code so that I can see where to use it.

Thanx again

 

[StevenK]

Right Click your TTable or TQuery component and select 'Field Editor' from the pop up menu. Right click the list (if empty) and select 'Add All Fields' - this should then create the Field list for the TTable/TQuery component. In this list, highlight a field and hit F11 for the Field's object inspector. Select the 'DisplayFormat' property and entry '0.000' (without the single quotes).
Steve