One of my customers recently reported an error when using my customization:
Cannot edit a record in my custom table (MyCustomTable). The record already exists.
We are unable to debug on the customer's system so I'm not exactly sure what caused this error but I'm curious if anyone has ever seen this before. The error message doesn't make sense to me. It would make sense to get an error that you could not INSERT a record in my custom table because the record already exists but what does that even mean that you cannot EDIT a record that already exists?
*This post is locked for comments
Thanks a lot for the reply, Joris. That makes perfect sense.
It is likely you are updating the record's primary key, which makes it conflict with an existing record.
Let's say you have a table with 1 column which is the primary key, called "ID". Your table contains 2 record, with ID "a" and ID "b". If you now select the row with ID "b" and updated the ID column to "a" and call update, you will get this error message.
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
Community Member
48
Zain Mehmood
6
Moderator