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
Corrupt ClientDataSet content with TOraQuery
Re: Corrupt ClientDataSet content with TOraQuery
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
Hi, is the bug fixed? When are you going to release the fix?
Re: Corrupt ClientDataSet content with TOraQuery
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
Perfect, when are you planning to release it officially?
Re: Corrupt ClientDataSet content with TOraQuery
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.