n 24 June 2013 14:58, Michael Hall <[email protected] <javascript:>> wrote:
> Was there ever a fully working solution proposed or discovered for using
>> executesql with grid and smartgrid?
>>
>>
> I don't know of any. What I sometimes do is to use create views or tables
> containing the results of complicated SQL-queries and use them from DAL to
> view the results in grids.
>
Probably not the most efficient, but you might also be able to do something
like:
mem_db = DAL('sqlite:memory')
Then put the contents of a complex .executesql() query into a mem_db table
and use that table in the grid.
Anthony
--
---
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.