Updating Table and combined SQL
Posted: Mon 03 Jul 2006 12:47
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.
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.