we notice a strange problem with your TMSQuery component since the last update to version 8.0.2.
We use a query with field aliases and since last version we noticed that this fields are not updated if modified. If we use the dbMonitor, the update command does not contain the update of all fields from the updating table wich have an alias.
For example, with this query:
Code: Select all
SELECT A.FIELD_1, A.FIELD_2, A.FIELD_3 AS NEW_FIELD_NAME, B.FIELD_A FROM TABLE_1 A LEFT OUTER JOIN TABLE_2 B ON A.FIELD_2 = B.FIELD_2
With old versions of your components the update works great. Did you change the behaviour for the creation of the update command of the TMSQuery component in new version? Or is it a bug?
This is a big problem for us because we have a lot of programs that use your component with field alias.
Thanks in advance