RE: [sqr-users] Temp Table Error

["the dragon" <ceprn@hotmail.com>]

Sam,

I agree with Peter - it looks like the column you are selecting from in the 
temp table has been defined as a character column.

Angelika - that would probably work, but should not be necessary; you should 
be able to do that compare with the sqr column variable without modifying it 
if it is coming from a numeric column.

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

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

_________________________________________________________________
Use your PC to make calls at very low rates 
https://voiceoam.pcs.v2s.live.com/partnerredirect.aspx


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