> Note that db2 ODBC SQL statements should NOT end with semicolon ';'. and this resembles the kind of error I got.
carlo On 25 Feb, 22:18, DenesL <[email protected]> wrote: > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
