|
View previous topic :: View next topic
|
| Author |
Message |
sathish_rathinam
New User
.jpg)
Joined: 22 Aug 2005
Posts: 59
Location: india
|
|
|
|
Is there any function for checking a decimal value for NUMERIC condition.
I tried checking 99.99 value is NUMERIC, but i got the result showing 99.99 in not a NUMERIC. How can we process this without a INSPECT statement. |
|
| Back to top |
|
 |
vasanthkumarhb
Active User
Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex
|
|
|
|
Hi,
you can make use of EVALUATE function.
like
| Code: |
EVALUATE TRUE
WHEN VARIABLE = 0000.00 THRU 9999.99
STATEMENT
STATEMENT
STATEMENT
WHEN OTHER
DISPLAY ' CHECK CONDITION FAILED'
END-EVALUATE |
This will not work in all cases. |
|
| Back to top |
|
|
sasikaran
New User
Joined: 24 Jun 2008
Posts: 3
Location: chennai
|
|
|
|
| We cant check the numeric for decimal values..U can check for the filed from which the 99.99 is moved. |
|
| Back to top |
|
|
sasikaran
New User
Joined: 24 Jun 2008
Posts: 3
Location: chennai
|
|
|
|
The other option is to MOVE the 99.99 to a working storage variable of 99v99 and check Numeric for this Working storage field.
Hope this helps. |
|
| Back to top |
|
|
|
|
