Re: [web2py] Re: Error db._adapter

2015-12-09 Thread Hector Chacon
good afternoon, I explain how to solve the problem in question, so that the method ".executesql" the DAL object fails with the message "'NoneType' object is not iterable" the problem is that when you run a stored procedure, the method attempts to obtain the return of the execution of the senten

[web2py] Re: Defining stored procedures

2015-11-30 Thread Hector Chacon
Yarin Hello, good afternoon, I take your question to answer in general terms as used in web2py Procedures. 1- sure that the database engine you use supports stored procedures (ex: mysql, postgresql, Sybase, Oracle, etc). 2- must create the procedure in the database using the SQL client that corr