Unique Constraint Failed, Why?

Das Goravani goravanis at gmail.com
Sat Sep 18 17:53:20 UTC 2021

Hello $all,

I am doing what I think is really routine stuff.

But I can’t save data for one table, it gives the error “Unique constraint failed”

The column it fails on is the Primary Key, which is column type “Sequence”.

On all my many $schemas I have a field like CustRSN type Sequence and it’s marked as Primary Key

I find on these unique columns all the time and they are the primary key that Updates work by.. always works, no problem.

But today on this one table it’s not working. 

It’s giving that error. It won’t Update data. 

I have reindexed the data twice, and no joy. 

What can be doing this?  It is 10.2 30204 and SQLite

There is nothing special going on with this one today.. this should work but it won’t. 

Any ideas? 

I’m up to the point where I’m considering doing an export and import to build a new database table out of the 1000 records in it. 


More information about the omnisdev-en mailing list