Hello,
After successfully connecting to the database I tried altering the
definition of a table from this:
db.define_table('node_details',
Field('uid', 'integer', notnull=True),
Field('title', length='255'),
Field('body', 'text'),
Field('teaser', 'text'),
Field('node_id', db.node))
to this:
db.define_table('node_details',
Field('uid', 'integer', notnull=True),
Field('title', length='255'),
Field('body', 'text'),
Field('node_id', db.node))
I have drop the teaser field.
Then I refreshed the page, and I got this error:
Traceback (most recent call last):
File "C:\web2py\gluon\restricted.py", line 173, in restricted
exec ccode in environment
File "C:/web2py/applications/init/models/db.py", line 77, in
<module>
Field('node_id', db.node))
File "C:\web2py\gluon\sql.py", line 1275, in define_table
t._create(migrate=migrate, fake_migrate=fake_migrate)
File "C:\web2py\gluon\sql.py", line 1734, in _create
fake_migrate=fake_migrate)
File "C:\web2py\gluon\sql.py", line 1788, in _migrate
self._db._execute(sub_query)
File "C:\web2py\gluon\sql.py", line 1067, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
ProgrammingError: (-104, 'isc_dsql_prepare: \n Dynamic SQL Error\n
SQL error code = -104\n Token unknown - line 1, column 31\n COLUMN')
The output from sql.log is as follows:
....
ALTER TABLE node_details DROP COLUMN teaser;
The problems is that for dropping a column, firebird and interbase
doesn't accept the COLUMN keywork, you should write ALTER TABLE tbl
DROP col instead of ALTER TABLE tbl DROP COLUMN col
Regards
Salva
--
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.
