Thank you! That worked.
On Jun 16, 6:53 am, Massimo Di Pierro <massimo.dipie...@gmail.com>
wrote:
> These:
>
> db.testtable.name.requires=IS_NOT_IN_DB(db, db.testtable.name)
> db.testtable.name.requires = IS_ALPHANUMERIC()
>
> shuld be
>
> db.testtable.name.requires= (IS_ALPHANUMERIC(),IS_NOT_IN_DB(db,
> db.testtable.name))
>
> otherwise the second requires overrides the previous ones, web2py
> checks only for IS_ALPHANUMERIC, not uniqueness and the database
> checks for uniqueness raising an exception.
>
> On Jun 16, 12:27 am, matt grham <matt.gr...@gmail.com> wrote:
>
> > Hi All,
>
> > The following table definition does not work all the time. Sometimes
> > it gives the following error: IntegrityError: column name is not
> > unique. I want to receive the error at the form level.
>
> > db.define_table('testtable',
> > Field('name', 'text', unique=True, notnull=True),
> > migrate=True)
>
> > db.testtable.name.requires=IS_NOT_EMPTY()
> > db.testtable.name.requires=IS_NOT_IN_DB(db, db.testtable.name)
> > db.testtable.name.requires = IS_ALPHANUMERIC()
>
> > Note: If I comment db.testtable.name.requires = IS_ALPHANUMERIC(), I
> > can get the error at the form level.
>
> > Did anybody observe this behavior? I am using sqlite database.
>
>
