🚀 go-pugleaf

When I add "save to" to the line as follows;

select sum((rate* N_of_pages)+ price) tot_inv, sum(Etax) t_Etax from bill
where bill_n= :t_recno save to temp_1

the very next line;

a= tot_inv

gives the error, "Variable undefined. TOT_INV." I didn't have this problem
before adding the "save to" to the statement. What's the problem?

David

>
>
> You can use the SAVE TO option of SELECT to specify an actual on-disk table
> name, or use the ALIAS option to specify the alias of the open result set.
> Either way, just ensure that you close the result with the USE command when
> you're finished with it. That should also close any temporary tables as
> well.
> ____
> Bowen Moursund (TeamB)
> bowen at nerds dot com
> http://lonestar.texas.net/~moursund/
> Try this help resource:
>  http://www.dejanews.com/home_ps.shtml