'offset' is a keyword and cannot be used as a field name
On Mar 4, 10:34 pm, weheh <richard_gor...@verizon.net> wrote:
> This didn't used to issue a ticket until today. The only change I made
> was to add a new table to my db. Any idea what might be causing this?
> The db field is this:
>
> db.Field('offset','double',requires=IS_FLOAT_IN_RANGE(-12.0,12.0)),
>
> Traceback (most recent call last):
> File "gluon/restricted.py", line 173, in restricted
> exec ccode in environment
> File "/web2py/applications/myapp/models/C_db.py", line 175, in
> <module>
>
> db.Field('offset','double',requires=IS_FLOAT_IN_RANGE(-12.0,12.0)),
> File "gluon/sql.py", line 1275, in define_table
> t._create(migrate=migrate, fake_migrate=fake_migrate)
> File "gluon/sql.py", line 1694, in _create
> self._db._execute(query)
> File "gluon/sql.py", line 958, in <lambda>
> self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> ProgrammingError: syntax error at or near "offset"
> LINE 4: offset FLOAT8
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
