SQL Error when trying to update a SQL Server row

[SARO_Consulting]

HI everyone!

I’m having a bad time with this issue…

I followed Appsheet recommendations about Indentity Keys and UniqueIDs to have the “best of both worlds”

When I add a record, everythings works fine…

But, when I try to update a record, Appsheet send me this error:

Identity field on Appsheet is set to non updatable nor required, just “show”

UniqueID field is the key to reference everything else.

I don’t understand why Appsheet is trying to edit the identity column when it’s set only to be read, with no formula, no initial value… nothing…

Have this issue with 2 main tables…

Is there’s something missing on my side or, Appsheet’s post procedures are not accurate.

Hope anyone can clarify this for me.

Thanks in advance