Massimo,

in your sql.py starting at line 295 change:

#       'id': 'ROWID NOT NULL',
        'id': 'INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY',
#       'reference': 'INT, FOREIGN KEY (%(field_name)s) REFERENCES %
(foreign_key)s (id) ON DELETE %(on_delete_action)s',
        'reference': 'INT, FOREIGN KEY (%(field_name)s) REFERENCES %
(foreign_key)s ON DELETE %(on_delete_action)s',

you can not use ROWID with db2/400, it is not integer field.

Note that db2 ODBC SQL statements should NOT end with semicolon ';'.

Denes.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@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
-~----------~----~----~----~------~----~------~--~---

Reply via email to