Devart Forums

TMyQuery renames fields if they are identical in two tables:

T1.ID, T2.ID => QueryFields: ID, ID_1;

Setting doesn't really help because subsequent update operations raise an exception: "Field ID_1 cannot be found in T2".

Workaround, if all fields from both tables (SELECT *) are required?

In order to solve the problem you can rewrite a SQL query using the AS statement, like this: Also you can use SQLUpdate property to specify the SQL statement that will be used when applying an update to a dataset. You can find more detailed information about this property in the MyDAC help.