Devart Forums

When a delete is done witha tUniquery mysql mode there is no result, exept internally but no delete is done in the MYSQL IF the uniquerys SQL contains a JOIN. With no join it works fine.

If several tables take place in a query, MyDAC allows data modification in one table only. To specify the name of the table to modify data, there is the TMyQuery.UpdatingTable property. If this property is not set, MyDAC uses the first table in the SELECT statement for modification by default. See more details about this property in MyDAC help:https://www.devart.com/mydac/docs/?deva ... gtable.htm