- This topic has 2 replies, 2 voices, and was last updated 4 years, 2 months ago by
.
Viewing 2 reply threads
Viewing 2 reply threads
- You must be logged in to reply to this topic.
kimbomadsen.
TomYUhi,
For ClientQuery, when parsing on the server side, if a field is not modified, I don’t want it to be generated in the Set clause of Update.
What should I do?
best regards
Tom YU.
TomYUA ClientQuery has F1,F2,F3 fields, F1 is primary key，when i modify F2, I want to generate SQL like this: update testtable set (f1,f2) values (‘aaa’,’bbb’) where f1=xxx.
kimbomadsenHi,
Currently the resolver resolves all fields equally. Hence it is possible not to resolve a specific field, but then it is not resolved for any of the records about to be resolved back to the database.
Technically kbmMW could support creating a new unique statement for each record to resolve back, but it would limit performance.
It would require creating a new database resolver that would compare old and new values for each field, to determine which SQL statement to product.
But it is not trivial.
Kim/C4D