🚀 go-pugleaf

I finally figured out the problem. The original code was,

**Wrong**
select sum((rate* N_of_pages)+ price) AS tot_inv, sum(Etax) AS t_Etax from bill ;
     where bill_n= :t_recno save to "temp1.dbf"
  select tot_inv, t_Etax from temp1
  a= tot_inv
use
 drop temp1
**Wrong**

Which give the following error, "Error; Table already open, temp1,"  when I try
to drop the table. I needed to close the temp1 table. It looked like use wouldn't
close an file opened with the select command, it would only close a file opened
with the use command. But the problem is when I issue the second select command, I
am in a new work area. The code should read;

**Correct**
select sum((rate* N_of_pages)+ price) AS tot_inv, sum(Etax) AS t_Etax from bill
where bill_n= :t_recno save to "temp1.dbf"
use
     select tot_inv, t_Etax from temp1
  a= tot_inv
use
 drop temp1
**Correct**

This closes the temp1 table in it's current work area before opening it again to
get the values, and then recloses it.  I'm still not quite sure why I can't get the
values tot_inv and t_Etax without reopening the table. I suppose it just creates
the table, but has no recollection of what tot_inv or t_Etax is.

David