Page 1 of 1

Corrupt ClientDataSet content with TOraQuery

Posted: Fri 06 Oct 2017 11:13
by Morelli
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

Re: Corrupt ClientDataSet content with TOraQuery

Posted: Tue 10 Oct 2017 15:17
by MaximG
Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

Re: Corrupt ClientDataSet content with TOraQuery

Posted: Wed 22 Nov 2017 08:31
by Morelli
Hi, is the bug fixed? When are you going to release the fix?

Re: Corrupt ClientDataSet content with TOraQuery

Posted: Wed 22 Nov 2017 14:38
by MaximG
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

Re: Corrupt ClientDataSet content with TOraQuery

Posted: Mon 27 Nov 2017 10:18
by Morelli
Perfect, when are you planning to release it officially?

Re: Corrupt ClientDataSet content with TOraQuery

Posted: Mon 27 Nov 2017 14:19
by MaximG
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.