Can you make a concrete example? to some extend you can do this but in order to be general, it requires some programming. Provide an example I can can show I would do it.
On May 10, 12:26 pm, Vineet <[email protected]> wrote: > Hi, > I have a task related to the below-referred thread (but with a > different requirement). > I have multiple MySQL tables to be tackled in one form. > The user will make changes to certain fields. > As a result, > table1 might require : insert or update or delete or no operation; > table2 might require : insert or update or delete or no operation; > table3 might require : insert or update or delete or no operation; > > I can't predict as to what table will require which operation. > So it's not possible to hardcode the operation like > form[0].insert(2,TR.......etc. > > (In VFP, I am using a class called as CursorAdaptor (a visual DAL tool > out there), which monitors these operations on tables and executes > them to the database). > > A similar functionality would be of a great value to me in web2py. > > Is there any way to achieve this in web2py? > > Thanks in advance for your advice. > > Vineet. > ================================================ > > On Nov 21 2008, 7:05 pm, mdipierro <[email protected]> wrote: > > > > > > > > > You have the option of using form=SQLFORM and then form[0].insert(2,TR > > (...)) the rows from the other table. > > It may be easier to create the form using form_factory. > > > Massimo > > > On Nov 21, 12:34 am, mmstud <[email protected]> wrote: > > > > Im thinking to create an insert and update form with fields taken from > > > multiple tables. Person has address, email and phone instances on > > > separate tables, but for simple interaction, they should be present on > > > same form view. What is the best way to solve this kind of situation > > > at the moment, does SQLFORM the job? > > > > On update form there would be combobox with input and selectbox > > > combined. Input for new email, address, phone entries and select for > > > possible older entries. > > > > -Marko
