I have a field defined as Field('item_type','string',requires=IS_IN_SET(['Procedure','Consultation']))
db1.define_table('com_tier1',Field('item_nbr','string'),Field('doctorID','reference doctor'), Field('cmsn_pct','decimal(18,4)',requires = IS_DECIMAL_IN_RANGE(-1,1)), Field('cmsn_set', 'reference com_general_settings'), Field('item_type','string',requires=IS_IN_SET(['Procedure', 'Consultation'])),Field('item_desc','string'),migrate=False) When dispaying this table in SQLFORM.grid and then editing a row, instead of displaying the saved value in the field, I get blank in that field. @auth.requires_login() def tier1(): grid = SQLFORM.grid(db1.com_tier1,details=True,editable=True,create=True ,deletable=True) return dict(form=grid) It then fails validation if the user makes a change in another field and submits. What I am doing wrong? 2.3.2 with tables defined in MSSQL. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.