I can only confirm your "huh"!
Can you show me a typical console session? Are missing some
initialization statement?
On Feb 27, 11:02 am, DenesL <denes1...@yahoo.ca> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
