Data Mapping SELECT MAX(NUMBER_FIELD)

Data Mapping SELECT MAX(NUMBER_FIELD)

Postby LeoPrates » 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?
LeoPrates
 
Posts: 6
Joined: Fri 23 Dec 2016 10:35

Re: Data Mapping SELECT MAX(NUMBER_FIELD)

Postby LeoPrates » Thu 12 Jan 2017 11:37

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.
LeoPrates
 
Posts: 6
Joined: Fri 23 Dec 2016 10:35

Re: Data Mapping SELECT MAX(NUMBER_FIELD)

Postby MaximG » Mon 16 Jan 2017 14:03

We are glad that you found a necessary solution. Please don't hesitate to contact us with questions concerning dbExpress driver for Oracle usage.
MaximG
Devart Team
 
Posts: 375
Joined: Mon 06 Jul 2015 11:34


Return to dbExpress driver for Oracle