Re: [sqr-users] Temp Table Error

["PeterG Clark" <PeterG.Clark@vac-acc.gc.ca>]

Is it possible that std_hours is not defined as a numeric column in your temp 
table CREATE statement?

>>> Sam.McBride@radioshack.com 2006/10/17 11:54:55 >>>
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