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.


Reply via email to