Hello, I am trying to do some validation before updating a record. My idea is to verify that the new value of a field is bigger than the old one.
However I am not getting how to do it: table definition: db.define_table('t_myTable', Field('f_year', type='integer', label=T('Año')), Field('f_quantity', type='integer', label=T('cantidad')), Field('f_user', type='reference auth_user', label=T('Cargo'),default=auth.user_id,writable=False), auth.signature, format='%(f_year)s', migrate=settings.migrate) On my controller: # -*- coding: utf-8 -*- @auth.requires_login() def viewTable(): form = SQLFORM.smartgrid(db.t_myTable,onupdate=auth.archive,deletable= False,csv=False,details=False,searchable=False ,onvalidation=is_bigger) return locals() def is_bigger(form): idUpdate = request.args(3).first r = db(db.t_myTable.f_quantity==idUpdate.id).select() if r.f_quantity < form.vars.f_quantity: form.errors.f_quantity = 'Some error message ' % (r.f_quantity) I am not getting the way of get the OLD row value before update -- 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.