I am trying to create a cursor based on payroll_tbl created in SDT which contains regular and calculated fields. I need to add a calcuated field in my select statement. My calculated field in payroll_table is called totovertime. My sql statement can get regular fields as shown below:

				select pp, ;
					   fname, ;
					   newround(((totpay)/14)*ppdays1) as totpay, ;
					   newround(((fica)/14)*ppdays1) as fica, ;
					   newround(((retire_amt)/14)*ppdays1) as retire_amt, ;
					   newround(((health_ins)/14)*ppdays1) as health_ins, ;
			  		   newround(((retiree_med)/14)*ppdays1) as retiree_med, ;
					   newround(((unempins)/14)*ppdays1) as unempins, ;
					   newround(((wrkcompins)/14)*ppdays1) as wrkcompins, ;
					   newround(((total_salary)/14)*ppdays1) as total_salary, ;
						ssn ;
				from payroll_tbl into cursor cCursor2 where payroll_tbl.pp = a__gen10(1,1) ;
							and &lcFieldname == lcSomeVar order by fname

I need to include a calculated field totovertime in this select statement. Can that be done?


Thanks
Nick Patel