How can I display number(20) formatted columns without scientific notations?

[cagatay ozpolat]

Hello;

I've set in my code the following properties as true :
OracleDataSet.OracleDictionary.DisplayFormats:=True;
OracleDataSet.OracleDictionary.RangeValues:=True;

But I can not see the values of Number(20) formatted colums as the following:
9007199254796474761 (Without , and E notation)
Instead It is look like:
9,00719925479647E18

How can I change this Scientific notation to normal only digits view format.

Thanks ..
Cagatay

 

[Marco Kalter]

You can accomplish this by setting TOracleSession.Preferences.FloatPrecision to 19 (or less). Number fields with a precision that exceeds 19 digits will be handled as strings, and the Oracle Server will format these strings without using the scientific notation and with full precision.

 

[cagatay ozpolat]

It's Ok. I've taken succesfull result by adjusting TOracleSession.Preferences.FloatPrecision.

Thanks a lot for your interest..
Sincerely.
Cagatay