Invalid field name although rname is set

[Edwin Haver]

Hello,

Why do I get the following error message when I have set the rname for that field and have set check_reserved to None?

<type 'exceptions.SyntaxError'> Field: invalid field name: update, use rname for "funny" names

Version

web2py™	Version 2.14.6-stable+timestamp.2016.05.10.00.21.47
Python	Python 2.7.12: C:\Python27\python.exe (prefix: C:\Python27)

Traceback

1. 2. 3. 4. 5. 6. 7. 8. 9.

Traceback (most recent call last): File "C:\Users\Edwin\Applications\web2py\gluon\restricted.py", line 227, in restricted exec ccode in environment File "C:/Users/Edwin/Applications/web2py/applications/create/models/db_tables.py", line 24, in <module> Field('update', rname='wac_update', type='string', default=None), File "C:\Users\Edwin\Applications\web2py\gluon\packages\dal\pydal\objects.py", line 1438, in __init__ 'use rname for "funny" names' % fieldname) SyntaxError: Field: invalid field name: update, use rname for "funny" names

Regards, Edwin

[Niphlod]

update() is a method............you can't use a model that has a field that is named "update". It's true that you're using rname, but the problem is that you need to choose a less "funny" name for the field name, not the rname.

[Anthony]

Field names cannot be Python keywords or attribute names of the Table object, even if using rname. The Table class inherits from pydal.helpers.classes.BasicStorage, which has methods "update", "get", "keys", "values", etc. -- so none of those will work as field names (though you can use them as rnames).

Anthony

[Edwin Haver]

Thank you for the explanation. The error message is a bit misleading in this respect.