posted 18 years ago
I'm trying to update a row in a table which has a primary key, 4 unique keys (unique constraint) and a few more data fields. I have naturally one primary key specified for the table in my repository_user.xml file. When I store the row, I get a Unique restraint violation for the unique constraint on the 4 uks. The primary key value is generated using a sequence. Is there any way to configure the table so that it will update the row? Are there any settings you need to do this operation?