The db.define_table(...) does two things: 1) the first time it is executed it creates the table 2) the other times it is executed it informs web2py that you expect to have that table (if not it is recreated or migrated accordingly).
This means it has to be executed at every request. Not just in one controller. You can have a user click a button and create a table but the info about that table also have to be stored in the database so that it can be retrieved on sub-sequence requests. T3 does it. Look into the source code. On Sep 11, 12:32 am, wf321 <[email protected]> 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'): > db.define_table('sometable', .... > > redurect(r-request, f='nextpage') > > def nextpage() > if not db.has_key('sometable'): > showerror() > > when user call somepage(), it do create a new table 'sometable' in > database, after redirect > to nextpage(), 'sometable' still in database, but db.has_key > ('sometable') retun false, > > does anyone know what happen? > > and if change nextpage to db.has_key('db_py_table') ( db_py_table is > define model\db.py ) it retuen true. > > Can anyone help to tell me how to code to create table in controler > py and it can access by other function? > > Thanks a lot. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
