RE: [sqr-users] Temp Table Error

["Everett Carr" <ECARR@holycross.edu>]

for sqr numeric comparisions as well as date, you need to move 
the buffer vars into sqr vars
 
 
ie let #somenbr = &sometable.numberfield
 
if @comenbr = 0
   blah-blah
end-if
 
will work

>>> "Angelika Scheffera" <angelika_scheffera@msn.com> 10/17/2006 2:50
PM >>>
Clark,
Hehehe....  It probably is a feature.

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 1:37 PM
To: the dragon; sqr-users@sqrug.org 
Subject: RE: [sqr-users] Temp Table Error

Clark,

I can verify that when the table is created, the columns are defined
as
decimal. I also did a describe on the table after it was created and
all
the columns in question are "number".  I can move the values directly
to
a numeric variable without modification and the comparisons work fine.
Maybe it's an SQR "feature?"

Sam

-----Original Message-----
From: the dragon [mailto:ceprn@hotmail.com] 
Sent: Tuesday, October 17, 2006 1:21 PM
To: sqr-users@sqrug.org 
Cc: Sam McBride
Subject: RE: [sqr-users] Temp Table Error

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 


_______________________________________________
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