Re: SQR not recognizing number

[Bill Beckner <Bbeckner@ICC.CC.IL.US>]

Also, if eq8 is a column in your table, you'll need to assign eq8 as &eq8,
changing your if statement to:

If &eq8 >= 50

HTH!

--
William Beckner -- Stunt Programmer (Just call me "Bill")
Illinois Central College, Rm L141 -- East Peoria, IL  61635-0001
PH: (309) 694-8419 -- FAX: (309) 694-8995
"I don't need any of that SQL stuff -- I just want a database!"

 -----Original Message-----
From:   Hins, Thomas D. [mailto:Thomas-Hins@OUHSC.EDU]
Sent:   Friday, November 30, 2001 11:10 AM
To:     SQR-USERS@list.iex.net
Subject:        Re: SQR not recognizing number

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