Thanks Carlo Sirna for trying to help and sorry for not responding back sooner. I never got any notifications of a new answer to my post.
Sadly your reply is based on a wrong assumption that I am changing the primary key, which I am not(!).
In the test table i mentioned, I get the error when changing the value of ALLOWNONSTDSIZE. This is clearly a bug.
If allroundautomations would bother reading my email with a test project they would probably see right away.
If anyone will try this then create the table as mentioned earlier on a non-unicode database (on unicode database it works).
Then insert this test data:
Insert into TEST_PRICELISTCODES
(PRICELISTID, STDPRODUCTID, ALLOWNONSTDSIZE)
Values
('NY15', 'TS', 1);
Insert into TEST_PRICELISTCODES
(PRICELISTID, STDPRODUCTID, ALLOWNONSTDSIZE)
Values
('NY15', 'DIDCHRISTOPHERSP5KT', 1);
Create a test application that loads this data and try to change the value of the column ALLOWNONSTDSIZE. On the row with the value 'TS' in the column STDPRODUCTID it works, but in the row with 'DIDCHRISTOPHERSP5KT' you get "Record changed by another user".
Last edited by Fredrik; 12/14/15 12:02 PM.