Can not update preside object if the ID is auto

Description

I went to data manager, click updated an exist record then I got an error.
Root cause is: MS SQL don't allow update the ID if it is auto.
Solution is remove ID file out of Update query:
by replace:
for( col in arguments.updateColumns ) {
entity = hasAlias and ListLen( col, '.' ) eq 1 ? "#col#" : col;
sql &= delim & " " & escapeEntity( entity ) & " = :set__" & col;
delim = ",";
}

By

for( col in arguments.updateColumns ) {
if(col != "id") {
entity = hasAlias and ListLen( col, '.' ) eq 1 ? "#col#" : col;
sql &= delim & " " & escapeEntity( entity ) & " = :set__" & col;
delim = ",";
}
}

Environment

MS SQL 2008

Assignee

Manikandan M

Reporter

MinhN

Labels

Accepted

Yes

Fix versions

Affects versions

Priority

High
Configure