Re: [web2py] Re: unique entry or null validation

2014-04-13 Thread Claudio Cocciarelli
If you want the items in field1 to be uinique then you cannot allow update to put a duplicate value in there. If you get that message, find the duplicate value in the database and do something about that. Regards Johann As I mentioned, it's difficult to explain :) I don't want

Re: [web2py] Re: unique entry or null validation

2014-04-10 Thread Johann Spies
On 9 April 2014 17:45, Claudio Cocciarelli claudiococciare...@gmail.comwrote: So I have a db.table.field1.requires=IS_EMPTY_OR(IS_NOT_IN_DB(db, 'table.field1')) but I have a problem with this: when inserting a new record it works flawlessly, instead when updating another record field2 in the