The error message suggests that it is the field name (ie, "position") that
is reserved.
On Monday, July 21, 2014 4:19:39 PM UTC+12, Simon Ashley wrote:
>
>
> 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.
