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

> > >> > 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

[web2py] Re: unique entry or null validation

Hi, I'm bringing back this very old post because I'm dealing with this exact issue right now. 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 "