There is no mechanism for temporary tables.
The options are
1) user db.executesql to define the temporary table then make it
visible to web2py DAL using db.define_table
('yourtemptable',....,migrate=False)
2) use a Rows object instead of a temporary table.

If you show us an example of the raw SQL you would use, we can perhaps
provide a more concrete example of solution.

Massimo

On Oct 14, 11:46 pm, wf321 <[email protected]> wrote:
> in web2py is there anything like tempory table  and store procedure ?
>
> people not suggest to use tempory table for DAL
>
> but what is the good solution to handle complex query?
>
> For example, there are tables A,B,C,D,E ...
>
> 1)  result1 = join A,B,C
>
> 2) update some rows in result1
>
> 3)  then base on rows count of result1, need join result1 to
> different
>    table (C.. or D,E..) and return different fields
>
> handle this can use tempory table in store procedure in database ,
> anyone know how to do it in web2py with DAL (not db.executesql ) ?
>
> thanks.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to