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.


Reply via email to