updating table not from sqltext

stunt · Post by **stunt** » 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.

AlexP · Post by **AlexP** » Thu 27 Jan 2011 14:02

Hello,

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

stunt · Post by **stunt** » Thu 27 Jan 2011 14:19

Version 5.80.0.43 for Delphi 7

AlexP · Post by **AlexP** » 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.

stunt · Post by **stunt** » Wed 02 Feb 2011 09:13

Thank you for your help.

AlexP · Post by **AlexP** » Wed 02 Feb 2011 10:41

Hello,

If any other questions come up, please contact us.