Page 1 of 1

Data Mapping SELECT MAX(NUMBER_FIELD)

Posted: Wed 11 Jan 2017 13:25
by LeoPrates
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?

Re: Data Mapping SELECT MAX(NUMBER_FIELD)

Posted: Thu 12 Jan 2017 11:37
by LeoPrates
Hi, again.

Sorry but I found the solution and it's very simple.
I'm migrating a Delphi 7 project to Delphi Berlin, and before those fields were created with the FieldKind property as fkData, just change to fkCalculated that resolved. :oops:
Thank you.

Re: Data Mapping SELECT MAX(NUMBER_FIELD)

Posted: Mon 16 Jan 2017 14:03
by MaximG
We are glad that you found a necessary solution. Please don't hesitate to contact us with questions concerning dbExpress driver for Oracle usage.