Oracle Number as Int64 or String Field

[Alconaft]

Hi.

I have column with number datatype as PK, max value in this column is over MaxInt.

DOA create this column as Float, and value of this column is lost.
Using To_Char and To_Number in SQL statements is impossible.

May be you have solution of this problem.

 

[Marco Kalter]

There are 2 possibilities:

1. You can use TOracleQuery.StringFieldsOnly or TOracleDataSet.StringFieldsOnly. Now all number and date fields will be fetched as strings, with full precision.

2. Set TOracleSession.Preferences.MaxFloatPrecision to 15 (for example). Now all numbers with more than 15 digits precision will be represented as strings, again with full precision.

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