Non-numeric input in numeric fields
From: james.jurista <jurista_at_cbnewsg.cb.att.com>
Date: Tue, 11 Aug 1992 20:08:00 GMT
Message-ID: <1992Aug11.200800.27180_at_cbfsb.cb.att.com>
Date: Tue, 11 Aug 1992 20:08:00 GMT
Message-ID: <1992Aug11.200800.27180_at_cbfsb.cb.att.com>
I'm using SQL*Forms 3.0 on an Amdahl UTS machine, and I have the following question:
How can I force non-numeric input to be ignored when the user is entering data in a numeric field? I want only numeric input echoed to the screen, everything else should be ignored. Is there any way to do this? If not, does anyone have suggestions for handling the error which results? First, the 50016 (Valid characters are...) error appears, followed by the 40735 (unhandled exception for VALUE_ERROR) error. I currently handle these in an ON-ERROR trigger which prints a message when the error code is 50016 and ignores the other error.
Thanks in advance,
Jim Jurista Received on Tue Aug 11 1992 - 22:08:00 CEST