Yes, I thought of a different DAL instance but for my situation it isn't really necessary since I can move when I do the commit() or just store that data elsewhere (the commit was really just to store a "I made it through this datetime" checkpoint record). I was more mentioning it for the next person that might find this.
On Wednesday, January 10, 2018 at 3:26:16 PM UTC-6, Anthony wrote: > > On Wednesday, January 10, 2018 at 2:48:34 PM UTC-5, Brian M wrote: >> >> Thank you Anthony, that works! >> >> Only issue is that while using iterselect() you apparently can't do your >> own db.commit() or else you'll get "Function sequence error (0) (SQLFetch)" >> I suspect that it may be closing the result set that your'e trying to >> iterate over. :\ >> > > The only other option would probably be to create a completely separate > DAL() instance for the other operations, as a separate instance will also > establish a separate connection to the database. If both sets of operations > use some of the same tables, then you'd also have to define those models > twice (you could do so by writing a function that takes a DAL instance and > defines the relevant tables on it). > > 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.