Ok, I understand your point. But this is a issue of DAL or what?
because I only update web2py to trunk version On Jan 8, 12:15 am, mart <[email protected]> wrote: > Probably just being unhappy with the case :) > > tecnoGradua != tecnogradua > > Mart :) > > Field("tecnoGradua", 'string', > > On Jan 8, 12:57 am, drayco <[email protected]> wrote: > > > Hi, this code works with web2py 1.89.5 with mysql > > > but with web2py in trunk and mysql it dosent works. > > > db.define_table("lentes", > > audit, > > Field("tecnoGradua", 'string', > > requires=IS_IN_SET(['MONOFOCAL','BIFOCAL','MULTIFOCAL']),label="Num. > > de Graduaciones"), > > Field("material", "string", requires=IS_IN_SET(['MICA CR-39','ORMA > > 1.50','HIGH INDEX','THIN & LITE 1.67 > > ASFÉRICA','POLICARBONATO','CRISTAL'])), > > Field("tipo", "string",requires=IS_NULL_OR(IS_IN_SET(['FLAT > > TOP','BLEND O YOUNGER','PROGRESIVOS','PROGRESIVOS VARILUX COMFORT > > NE','PROGRESIVOS COMPACTOS','PROGRESIVOS VARILUX COMFORT SHORT']))), > > Field("tecnoVisual", > > 'string',requires=IS_NULL_OR(IS_IN_SET(['PHOTOGRAY','TRANSITIONS'])),label= > > "Tecnologia > > de Visualización"), > > Field("tratamiento", "string",requires=IS_NULL_OR(IS_IN_SET(['CON > > ANTIRREFLEJANTE','ESPEJEADO','CRIZAL FORTE','CRIZAL ALIZÉ']))), > > Field('limitup','double', writable=False, readable=False), > > Field('limitdown','double', writable=False, readable=False), > > Field("promo", "double", requires=[IS_NOT_EMPTY(error_message='No > > puede estar vacio'),IS_FLOAT_IN_RANGE(0,10000,error_message='Debe ser > > un numero positivo entre 0 y 10000')], label='Precio de Promoción'), > > Field("precio", "double", writable=False, readable=False), > > Field("costo", "double", writable=False, readable=False), > > Field("observaciones","text", writable=False, readable=False)) > > > This is the traceback > > > Traceback (most recent call last): > > File "/home/drayco/web2py/gluon/restricted.py", line 188, in > > restricted > > exec ccode in environment > > File "/home/drayco/web2py/applications/movil/models/db.py", line > > 272, in <module> > > Field("observaciones","text", writable=False, readable=False)) > > File "/home/drayco/web2py/gluon/dal.py", line 3441, in define_table > > polymodel=polymodel) > > File "/home/drayco/web2py/gluon/dal.py", line 551, in create_table > > fake_migrate=fake_migrate) > > File "/home/drayco/web2py/gluon/dal.py", line 595, in migrate_table > > and not isinstance(table[key].type, SQLCustomType) \ > > File "/home/drayco/web2py/gluon/dal.py", line 3778, in __getitem__ > > return dict.__getitem__(self, str(key)) > > KeyError: 'tecnogradua' > > > Can I need to change something? > >
