Corrupt ClientDataSet content with TOraQuery

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Morelli
Posts: 15
Joined: Thu 19 Mar 2015 15:45

Corrupt ClientDataSet content with TOraQuery

Post by Morelli » Fri 06 Oct 2017 11:13

HI Folks,

we just have updated from ODAC Version 10.0.2 to 10.1.3.
In the new Version there is a new bug concerning property 'Fields' of the TOraQuery component.
In Version 10.0.2 the bug did not exist.

We use Embarcadero C++ Builder 10.2 Tokyo on Windows 10.

If we have a TOraQuery-component with the SQL query 'select a, b, c from atable' and then
manually fetch all fields in the fields-property-editor and CHANGE their order like:

Fields:
b
c
a

Then the ClientDataSet which is liked to the TOraProvider (which is liked to the TOraQuery) has a corrupt data-content!!!

Conclusion:
The bug is active if the TOraProvider.Fields do not have the exactly same order/quantity like the SQL-Statement of this component! New in Version 10.1.3.

If you Need a sample Project, I can send you a simple one.

Please fix this bug ASAP because we can not update to Version 10.1.3 because of this bug and had to roll-back to Version 10.0.2.

Another question:
I have observed that the property 'Fields' of the TOraQuery is shown grayed out in the Objectinspector in the IDE. What does this mean? Are they not supported anymore?

Kind regards
Michael Morelli

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

Re: Corrupt ClientDataSet content with TOraQuery

Post by MaximG » Tue 10 Oct 2017 15:17

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

Morelli
Posts: 15
Joined: Thu 19 Mar 2015 15:45

Re: Corrupt ClientDataSet content with TOraQuery

Post by Morelli » Wed 22 Nov 2017 08:31

Hi, is the bug fixed? When are you going to release the fix?

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

Re: Corrupt ClientDataSet content with TOraQuery

Post by MaximG » Wed 22 Nov 2017 14:38

We reproduced the issue and fixed this error. The fix will be included in the next ODAC build. As a workaround, we can send you a night ODAC build including the required changes. For this, using e-support form (https://www.devart.com the "Support"\"Request Support" menu) provide us with your license number and IDE version you are interested in

Morelli
Posts: 15
Joined: Thu 19 Mar 2015 15:45

Re: Corrupt ClientDataSet content with TOraQuery

Post by Morelli » Mon 27 Nov 2017 10:18

Perfect, when are you planning to release it officially?

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

Re: Corrupt ClientDataSet content with TOraQuery

Post by MaximG » Mon 27 Nov 2017 14:19

Currently, we do not have an exact release date of a new build of our products. However, we are planning to release this build within the next month.

Post Reply