Devart Forums

Posted: **Thu 27 Jan 2011 13:09**

Odac version 7.00.0.3 for Delphi 7
Problem is with TSmartQuery.

When I set updating table to the table mentioned in sqlText, everything is ok, but when I set an updating table to the table not from sqlText, then it seems that smartquery ignores updating table and sets first table of the sqltext into insert, update and refresh sqls.
In older version (5.80) TSmartQuery always used a value set in updating table.

Posted: **Thu 27 Jan 2011 14:02**

Hello,

Please specify the exact version of old ODAC (5.80.?.?)

Posted: **Thu 27 Jan 2011 14:19**

Version 5.80.0.43 for Delphi 7

Posted: **Tue 01 Feb 2011 09:23**

Hello,

We have really changed this behaviour, because it is incorrect to generate SQL statements from a table that does not exist in the query. Now you can manually generate Update, Insert, and Refresh SQL statements by entering the name of the needed table in the SQL Generator tab.

Posted: **Wed 02 Feb 2011 09:13**

Thank you for your help.

Posted: **Wed 02 Feb 2011 10:41**

Hello,

If any other questions come up, please contact us.

Devart Forums

updating table not from sqltext

updating table not from sqltext