Have you tried adding 'id' to your editable field list? [setattr(f, 'writable', False) for f in db.amc_master if f.name not in ['amcdesc','amcmod','complndays', 'id']]
-Jim On Wednesday, May 31, 2017 at 4:39:11 AM UTC-5, T.R.Rajkumar wrote: > > When I do SQLFORM.grid(db.amc_master) without setting any of the > readable/writable attributes the grid edit works fine. I am able to edit > and the form submits without errors. > Even with specifying the fields list grid edit works fine as the edit from > has all the fields of the table. > But when I set the readable/writable attributes to filter the fields in > edit form the the error 42000 listed above occurs. > Thank you Anthony for the test guidance. > How to go about now? > -- 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.
