Even after manually starting the journaling there are errors: Traceback (most recent call last): File "C:\web2py\trunk\gluon\restricted.py", line 98, in restricted exec ccode in environment File "C:/web2py/trunk/applications/test/controllers/appadmin.py", line 271, in <module> File "C:\web2py\trunk\gluon\globals.py", line 75, in <lambda> self._caller = lambda f: f() File "C:/web2py/trunk/applications/test/controllers/appadmin.py", line 103, in insert if form.accepts(request.vars, session): File "C:\web2py\trunk\gluon\sqlhtml.py", line 561, in accepts self.vars.id = self.table.insert(**fields) File "C:\web2py\trunk\gluon\sql.py", line 1331, in insert self._db._execute('SELECT IDENTITY_VAL_LOCAL();') File "C:\web2py\trunk\gluon\sql.py", line 790, in <lambda> self._execute = lambda a: self._cursor.execute(a[:-1]) ProgrammingError: ('42000', '[42000] [IBM][iSeries Access ODBC Driver] [DB2 UDB]SQL0104 - Token <END-OF-STATEMENT> was not valid. Valid tokens: + - AS <IDENTIFIER>. (-104) (SQLExecDirectW)')
I tried a few things with the IDENTITY_VAL_LOCAL() statement but no luck. 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 -~----------~----~----~----~------~----~------~--~---