🚀 go-pugleaf

On Mon, 28 Dec 1998 12:37:12 -0500, David M. O'Neil wrote:

> 
> 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?

You appear to be missing the word AS.

The select statement should be:

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


Gary

Some dBASE Stuff at
http://www.AppTools.com/dbase