On Feb 27, 11:36 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
> Sorry my fault
>
> self._execute = lambda a: self._cursor.execute(a[:-1])
>
> not
>
> self._execute = lambda *a: self._cursor.execute(a[:-1])
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 1303, in insert
self._db._execute(query)
File "C:\web2py\trunk\gluon\sql.py", line 790, in <lambda>
self._execute = lambda a: self._cursor.execute(a[:-1])
Error: ('HY000', '[HY000] [IBM][iSeries Access ODBC Driver][DB2 UDB]
SQL7008 - PERSON in QGPL not valid for operation. (-7008)
(SQLExecDirectW)')
I added a print before the _execute:
lastsql=INSERT INTO person(name) VALUES ('anna');
and if try the command on the AS400 server (without the ;)
insert into person(name) values ('anna')
1 rows inserted in PERSON in QGPL.
Huh?
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
-~----------~----~----~----~------~----~------~--~---
