Sorry SQLFORM.factory does not provide this functionality. On Thursday, 23 February 2017 12:44:15 UTC-6, lucas wrote: > > hello one and all, > > ok, so I have the basic code: > > btn = [INPUT(_type='submit', _name='submit', _value='Add 1-Step')] > btn.append(INPUT(_type='submit', _name='summary', _value='Add 1-Step > then Summary')) > frm = SQLFORM.factory(db.case, db.sheet, buttons=btn) > > which is great for merging fields from both tables into one form when > creating brand new records. but can I pass id's to SQLFORM.factory to > signal to it that I want to edit existing records instead of only insert. > something like: > > if (request.args(0) is not None): > cid = request.args(0) > else: > cid = None > if (request.args(1) is not None): > sid = request.args(1) > else: > sid = None > frm = SQLFORM.factory(db.case, db.sheet, buttons=btn, db.case.id=cid, > db.sheet.id=sid) > > or something to that effect. > > so if both cid and sid are None then factory will create both new, as > before. if cid is not None and perhaps sid is also not None, then factory > will automatically fill in the values from those particular records and > leave hidden inputs for the case.id and sheet.id signaling back to > process().accept that the > db.case.update(**db.case._filter_fields(from.vars)) will update the proper > record when it returns from being edited. > > or if factory doesn't inherently fill the fields if the record exists, > then we have to do a whole bunch through old-fashioned code? > > just looking for advice, thanx in advance, lucas > >
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
