Data Mapping SELECT MAX(NUMBER_FIELD)
Posted: Wed 11 Jan 2017 13:25
Hi.
I have a problem, I have Number(10) Fields in Oracle and I use it in my application doing "Select MAX(FIELD_NUMBER_10) From Table" and in my ClientDataSet these fields are TIntegerField but are giving the message "expecting: Integer, Actual: Float" But I need to keep them as TIntegerField.
I am currently using the parameters:
Params.Values['BCDPrecision'] := '0';
Params.Values['FloatPrecision'] := '38';
Params.Values['IntegerPrecision'] := '38';
Is there any data mapping parameter that can fix this?
I have a problem, I have Number(10) Fields in Oracle and I use it in my application doing "Select MAX(FIELD_NUMBER_10) From Table" and in my ClientDataSet these fields are TIntegerField but are giving the message "expecting: Integer, Actual: Float" But I need to keep them as TIntegerField.
I am currently using the parameters:
Params.Values['BCDPrecision'] := '0';
Params.Values['FloatPrecision'] := '38';
Params.Values['IntegerPrecision'] := '38';
Is there any data mapping parameter that can fix this?