mORMot Open Source

esmondb

Member

From: London

Registered: 2010-07-20

Posts: 299

unique field values

I've tried using 'stored false' to make a field unique. It works giving a ESQLException message 'constraint failed'. The problem is that the next record added always gives the error 'column Name is not unique' no matter whether the key field has unique data or not. Could you have a look? It can be reproduced in the sample app 2 by changing the TSQLSampleRecord.Name property to stored false.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,661

Website

Re: unique field values

If you do this with already existing data with duplicated values, the constraint is immediately failed.

Isn't it the issue in your case?

esmondb

Member

From: London

Registered: 2010-07-20

Posts: 299

Re: unique field values

Yes, this works, giving a fail on duplicate data. But the next record added always gives an ESQLException with the message 'column Name is not unique'.