[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[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