we are making progress. This is a BD2 specific statement that I made
up. I expected an error here. What is the correct syntax to retrieve
the ID of the last inserted record?
Massimo
On Mar 2, 9:33 am, DenesL <denes1...@yahoo.ca> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
