Corrupt ClientDataSet content with TOraQuery
Posted: 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
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