[web2py:32930] tempory table and store procedure

in web2py is there anything like tempory table and store procedure ? people not suggest to use tempory table for DAL but what is the good solution to handle complex query? For example, there are tables A,B,C,D,E ... 1) result1 = join A,B,C 2) update some rows in result1 3) then base on r

[web2py:30696] Re: how to let end user (not developer) define table on fly

. Look into the source code. > > On Sep 11, 12:32 am, wf321 wrote: > > > > > I try let end user create their table on fly , for example, in > > default.py > > > I have 2 function > > > def somepage() > >     if not db.has_key('sometable'):

[web2py:30689] how to let end user (not developer) define table on fly

I try let end user create their table on fly , for example, in default.py I have 2 function def somepage() if not db.has_key('sometable'): db.define_table('sometable', redurect(r-request, f='nextpage') def nextpage() if not db.has_key('sometable'): showerror()