Data Mapping SELECT MAX(NUMBER_FIELD)

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
LeoPrates
Posts: 8
Joined: Fri 23 Dec 2016 10:35

Data Mapping SELECT MAX(NUMBER_FIELD)

Post by 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: 8
Joined: Fri 23 Dec 2016 10:35

Re: Data Mapping SELECT MAX(NUMBER_FIELD)

Post by 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.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Data Mapping SELECT MAX(NUMBER_FIELD)

Post by 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.

Post Reply