excessive number of decimals

[kanjaradze]

I try to use TOracleDataset entering
float value 1,23456 into field defined as number(20,4).
I see '1,23456' even after TOracleDataset.Post
and only after Refresh I see rounded value '1,2346'.
At the same time the behavior of the TTable is more expected:
it shows rounded value just after value is entered.
Is there a way to make TOracleDataset to act the same way?
Thanks.

 

[Marco Kalter]

You can set the DisplayFormat of the field.

If you don't have persistent fields, you can alternatively set the TOracleDataSet.OracleDictionary.DisplayFormats property to True. If for example a column is defined as number(7,2), the field's DisplayFormat will be ##,##0.00 and the EditFormat will be ####0.00 (so that the user is not bothered with the group separator when he or she modifies the value).

------------------
Marco Kalter
Allround Automations