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?
