I use the newest ODAC Version 5.70.1.33.
I have a TSmartQuery with SQL from different tables. To edit the DataSet i set the UpdatingTable property to the table i want to edit.
On opening of the DataSet the UpdatingTable property is cleared. If i try to edit the Dataset i get the error "UpdatingTable is not defined.".
Why the property is cleared?
In an older Version 5.55.1.24 it works.
I look'ed into your sources and found out that the Class TCustomDaDataSet has it's own variable FUpdatingTable and the Class TCustomSmartQuery, who is a descendant of TCustomDaDataSet, has also an FUpdatingTable. When the property UpdatingTable of TSmartQuery is set only FUpdatingTable of TCustomSmartQuery is set. But internally you are working with the FUpdatingTable from CustomDaDataset which is not set. I think there is a problem in your class hierarchy.
Please fix this.
I don't send a sample because this problem is easy to reproduce.
Updating Table and combined SQL
-
Challenger
- Devart Team
- Posts: 925
- Joined: Thu 17 Nov 2005 10:53
Re: Updating Table and combined SQL
Hello,cis-wurzen wrote:I use the newest ODAC Version 5.70.1.33.
I have a TSmartQuery with SQL from different tables. To edit the DataSet i set the UpdatingTable property to the table i want to edit.
On opening of the DataSet the UpdatingTable property is cleared. If i try to edit the Dataset i get the error "UpdatingTable is not defined.".
Why the property is cleared?
i updated from ODAC Version 4.15 to 5.80.0.37 (Delphi 6) and now i have the same problem like cis-wurzen had. In the older version 4.15 it works without problems.
When i set the UpdatingTable property of the TSmartQuery and then set Active to true, the UpdatingTable property is cleared.
In the history you wrote that is was fixed in version 5.70.1.34.
Could you please fix it again?
Thanks.