TEMP tables and CURSORS
Using 4GL versoin 4.1
Can you declare a cursor that joins a TEMP tables with a table that exits in
the database?
i.e.
declare q_curs cursor for
select key, count(*) t1tot
from table1
group by key
into temp x;
select key, x.t1tot
from table2, x
where table2.key = x.key
↪ replying to David Tucker
David Tucker wrote:
>
> Using 4GL versoin 4.1
>
> Can you declare a cursor that joins a TEMP tables with a table that exits in
> the database?
>
> i.e.
>
> declare q_curs cursor for
> select key, count(*) t1tot
> from table1
> group by key
> into temp x;
> select key, x.t1tot
> from table2, x
> where table2.key = x.key
Sure. Works like a charm. (This one you could just try. :^) )
Art S. Kagel