Page 1 of 1

Updating Table and combined SQL

Posted: Mon 03 Jul 2006 12:47
by cis-wurzen
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.

Posted: Wed 05 Jul 2006 07:38
by Challenger
We fixed this problem. This fix will be included in the next build of ODAC.

Re: Updating Table and combined SQL

Posted: Mon 18 Dec 2006 13:29
by renez
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?
Hello,

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.

Posted: Tue 19 Dec 2006 14:29
by Plash
We have fixed this problem. The fix will be included in the next build of ODAC.

Posted: Fri 29 Dec 2006 10:11
by renez
plash wrote:We have fixed this problem. The fix will be included in the next build of ODAC.
You wrote this information 10 days ago, when will the next build come? I´m sorry for my impatience, but this fix is very important for my company.

Posted: Tue 02 Jan 2007 10:11
by Plash
The new build of ODAC with the fix will be released on the next week.