RE: [sqr-users] Temp Table Error

["Angelika Scheffera" <angelika_scheffera@msn.com>]

Sam,
Have you tried moving the variable &std_hours into a number variable?  i.e. 

Move &std_hours to #std_hours
If #std_hours = 0

Angelika



-----Original Message-----
From: sqr-users-bounces+angelika_scheffera=msn.com@sqrug.org
[mailto:sqr-users-bounces+angelika_scheffera=msn.com@sqrug.org] On Behalf Of
Sam McBride
Sent: Tuesday, October 17, 2006 9:55 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Temp Table Error

I'm trying to create and use a temp table in an SQR program.  Everything
seems to work ok until I try to select from the table.  When I try to
use the selected columns in an expression, I get the following error:
(SQR 4048) Function or operator '=' must be a string or date argument.
This only happens for numeric colums.  For instance 

if &std_hours = 0   generates this error 
if &std_hours = '0' does not and the program runs and seems to do the
calculations correctly.

Does anyone know why I can't use numeric columms this way?  Why do I
have to treat a numeric value as a string and why does that work? 

Thanks in advance for your help  
Sam McBride
Peoplesoft HR/Payroll
817.415.1425
sam.mcbride@radioshack.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users