Unique constraint violated, but I don't see how.
tharpaApr 6 2012 — edited Apr 9 2012I have a tabular form on a table with a three-field primary key, so I had to make a column with a generated primary key just for Apex.
Normally it works fine, but when I try to update one paritcular record, I get a "unique constraint violated" error. Only trouble is, according to the data I am entering, I am not violating the named unique constraint. Indeed, I can update the record in the Object Browser window to the same values with no problem. And it does not seem to matter which values I use, I still have the same error in the tabular form.
You're probably familiar with the tabular form error messages - instead of the actual values, it says stuff like, "ADDITIVE_ID = :b2" so I cannot see if the new values are somehow different than the ones I can see with my own eyes in the tabular form.
Thanks.
3.2