This is a sqlite issue probable. You you stored string in there and then you change the type, there are still strings in there.
On Thursday, 22 November 2012 18:21:02 UTC-6, Mark Kirkwood wrote: > > Thanks, Niphlod - However amending the form definition as you suggested, > i.e: > > form=SQLFORM.factory( > Field('dogid', 'integer', > requires=IS_IN_DB(db(db.dog), 'dog.id', '%(name)s')), > ) > > gives the same behaviour - i.e field is still a str. > > > --