Haven't used rname before but the way I read it it should work with
reserved names. Have changed a given example to read:
db.define_table('easy_name',
Field <http://127.0.0.1:8000/examples/global/vars/Field>('position',
rname='"this_is_the_field_name"'),
rname='"this_is_the_easy_name_table"')
but it returns an error as follows:
Traceback (most recent call last):
File "C:\w2p_5\gluon\restricted.py", line 220, in restricted
exec ccode in environment
File "C:/w2p_5/applications/test_1/models/db_1.py"
<http://127.0.0.1:8000/admin/default/edit/test_1/models/db_1.py>, line 11, in
<module>
rname='"this_is_the_easy_name_table"')
File "C:\w2p_5\gluon\dal.py", line 8223, in define_table
table = self.lazy_define_table(tablename,*fields,**args)
File "C:\w2p_5\gluon\dal.py", line 8240, in lazy_define_table
table = table_class(self, tablename, *fields, **args)
File "C:\w2p_5\gluon\dal.py", line 8754, in __init__
check_reserved(field_name)
File "C:\w2p_5\gluon\dal.py", line 7931, in check_reserved_keyword
'invalid table/column name "%s" is a "%s" reserved SQL/NOSQL keyword' %
(name, backend.upper()))
SyntaxError: invalid table/column name "position" is a "ALL" reserved SQL/NOSQL
keyword
Running 2.9.5
*There there something I've overlooked? TIA*
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
