Good point. I was using ver 1.99.2. I tried with the 1.99.4 and now It shows a different error for the same contoller. Hm... strange.
Contoller (update:NG) ------------------------------ def test(): return dict(form=crud.update(db.IQWAGFTY, db.IQWAGFTY(db.IQWAGFTY.TYPRCD=='000115126002200'))) Traceback: ------------------------------------ Traceback (most recent call last): File "C:\web2py\gluon\restricted.py", line 204, in restricted exec ccode in environment File "C:/web2py/applications/Inventory_Reserve_Admin/controllers/ default.py", line 113, in <module> File "C:\web2py\gluon\globals.py", line 172, in <lambda> self._caller = lambda f: f() File "C:\web2py\gluon\tools.py", line 2533, in f return action(*a, **b) File "C:/web2py/applications/Inventory_Reserve_Admin/controllers/ default.py", line 69, in test db.IQWAGFTY(db.IQWAGFTY.TYPRCD=='000115126002200'))) File "C:\web2py\gluon\tools.py", line 3069, in update detect_record_change = self.settings.detect_record_change): File "C:\web2py\gluon\sqlhtml.py", line 1140, in accepts '%s != %s' % (record_id, self.record_id) SyntaxError: user is tampering with form's record_id: {'TYPRCD': None} != {'TYPRCD': '000115126002200'} On Feb 8, 2:35 pm, Niphlod <niph...@gmail.com> wrote: > I tried with both sqlite and postgresql and it works as expected. Are you > sure you are using the last version of web2py ? exceptions and line number > don't match with 1.99.4 (that is the version I tested for your sample code, > the only different thing is that I don't have a DB2 instance available, > sorry)