On Wednesday, August 1, 2018 at 8:48:54 AM UTC-4, Rahul wrote: > > Hi Anthony, > I used *db.rollback**()* and viola - A lot of my failing stuff > started to work. I am rectifying the failing queries and still trying to > figure out the incorrect SQL statement that is causing the error. For below > question - Again if I print db.rollback() a *None* is returned. > What happens if you call db.rollback() right before running these queries > that are generating the error? > I still want to know what all does - > db.rollback() function what does it do exactly ? rollback previously > executed queries? It is working like a charm. >
This is not the ideal solution because you may be rolling back good queries that you would otherwise want to commit. You should try to identify what queries are causing problems. Do you have any queries in a try/except that could be causing (uncaught) errors? What other queries are running before you get to the queries you have shown? Anthony -- 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.
