TIntegerField

[windon]

Take this example table

CREATE TABLE TEST
(
NUM 1 INTEGER,
NUM 2 NUMER(4)
);

In my Application when I add the fields in the fields editor all the TFields created are TFloatFields, but I would like a TInteger Field to be created.

Is there any configuration about this ?

Thanks For Reading
Juliano/Brazil

 

[Marco Kalter]

By default all number fields with a precision of 9 digits or less and without a scale will be treated as TIntegerFields. Your number(4) example should be a TIntegerField.

You can override this default behavior by setting the TOracleSession.Preferences.IntegerPrecision property:

Maximum precision to be represented an integer field. Setting this property to 0 will cause all integer numbers with a precision of 9 digits or less to be represented as an integer, and all other numbers as a floating point value, depending on the FloatPrecision preference. This preference affects fields in TOracleQuery and TOracleDataSet components.

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