There are several options but the simplest solution is: form = SQLFORM(db.t_bills, bill['id'], fields=['f_name'])
this way you only affect the listed fields. On Apr 27, 7:01 pm, Kenneth Lundström <[email protected]> wrote: > I have a table that I d like to update. Let s say the table has eight > different columns but at the time I d like to only update one of them > via a form. > > in controller: > form = SQLFORM(db.t_bills, bill['id']) > > if form.accepts(request.vars, session, keepvalues=True): > redirect() > > return dict(form=form) > > in view: > I have created a custom view with > {{=form.custom.begin}} > {{=form.custom.widget.f_name}} > {{=form.custom.submit}} > {{=bill_items_form.custom.end}} > > So I have only one textfield that can be updated. The problem I m facing > is that all rest columns are updated to a NULL value. I tried with > SQLFORM(db.fsdf, fields but no luck. > > Kenneth
