column type number(20)

[gerbay]

I have PrimaryKey Column data type Number(20)
and 1800 tables querying dynamic runtime.

Float prec 15 digit, Integer Field 9 digit

example numbers: -432345564215323988, -432345564215324109 ....

DOA 3.4.6.4 trial round numbers 15 digit

how can i retrive number(20) columns..

sory my bad english...

 

[Marco Kalter]

You would have to set TOracleSession.Preferences.FloatPrecision to (for example) 15. Now all numbers with a precision of 16 or greater will be treated as strings, without loss of precision.

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