you can reassemble the smaller ones in a view, define that view as migrate=False and query that with web2py. There's no support for UNION in web2py.
On Thursday, October 3, 2013 3:10:22 PM UTC+2, TYRANISTAR wrote: > > Hello everyone, > > I have a big mysql table that I want to break into smaller ones in order > to retrieve its results quicker via a web2py interface. Question is is > there a way to call a union of the smalleer tables via SQLFORM.grid (giving > the number and names of tables as arguments) and if not is there another > way? > > Thank you > -- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.

