a, i understand right now, thank you so much for your explaination and the test example niphlod.
While update()ing fields are translated to column names, so you don't have > to fetch the record just to increment it. > > >>>db.define_table('myupdates', Field('quantity', 'integer')) > >>>db(db.myupdates.id == 1)._update(quantity=db.myupdates.quantity + 1) > 'UPDATE myupda SET quantity=(myupda.quantity + 1) WHERE (myupda.id = 1);' > > > That piece of code (updating the product) is correct. -- --- 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/groups/opt_out.