Devart Forums

How can I influence the automatic updatesql in TMSQuery?
I would like to use only one key field in the where clause of the update query. I have set providerflags pfKey in the fieldobject of the key field but that does not work (I do not have an UpdateMode property in TMSQuery). Is there another way to accomplish this task without manually filling in the UpdateSQL property?

The algorithm of the choice key fields in SDAC is greatly optimized and in common case, it uses minimal required set of the fields. According to that in your case several fields are used, there is no any unique key field in the query.

Most probably, changing table structure with specifying an unique key filed will solve the problem

Putting a key on the table solved the problem.
Thank you!