2. PHPRunner General questions
  3. [SOLVED]  Edit Page Error - Cannot update identity column
This topic is locked
[SOLVED]

 Edit Page Error - Cannot update identity column

 		6/12/2020 9:42:43 PM
PHPRunner General questions
R
 RBrogen author

Hi Everyone,
I have an order form that I use the identity column as the Order Number. When I add that field to my Edit page, as READONLY because I don't want to update it just display it, and try to save my record I get the error shown in the figure below. I don't want to update the identity column value, just display it on the edit form. Not sure what I'm missing but if anyone can point me in the right direction I would greatly appreciate it.
Sergey Kornilov admin 6/13/2020

Readonly fields still are updated (because you can, theoretically, manipulate them via code).
What you need to do is to prevent this column from being updated using the technique explained in this article:

https://xlinesoft.com/phprunner/docs/update_multiple_tables.htm
R
 		RBrogen author 6/13/2020



Readonly fields still are updated (because you can, theoretically, manipulate them via code).
What you need to do is to prevent this column from being updated using the technique explained in this article:

https://xlinesoft.com/phprunner/docs/update_multiple_tables.htm


Perfect Sergey! Thanks ... using unset resolved the issue.