Re: SQR not recognizing number

["Hallmark, Robert J" <robert.j.hallmark@LMCO.COM>]

Thanks to all for the quick response.  Everyone had the right answer.
Changing to a numeric variable and removing the quotes resolved the problem.

Bob H

-----Original Message-----
From: Hins, Thomas D. [mailto:Thomas-Hins@OUHSC.EDU]



You might try assigning eq8 as #eq8 and removing the quote around 50
thus changing it to
if #eq8 >= 50
  do print
end-if

-----Original Message-----
From: Hallmark, Robert J [mailto:robert.j.hallmark@LMCO.COM]
Sent: Friday, November 30, 2001 10:48 AM
To: SQR-USERS@list.iex.net
Subject: SQR not recognizing number


SQR 6.1.3
Oracle 8.5

I am having a problem with SQR not recognizing a number as follows:

Here is the script:

if eq8 >='50'
do print
end-if

The value of eq8 is 2500, however the print procedure does not execute
unless my greater than figure is 25 or less.
So when I use  (if eq8 >= '25') or I use (if eq8>= '24') the print
procedure
executes.

By the way, I have verified that the figure is actually 2500 by
selecting
the row where value = '2500'.

Any idea what could be going on here??


Thanks


Bob H