Home » Developer & Programmer » Forms » validation checks on the character
validation checks on the character [message #83795] Fri, 12 December 2003 08:37 Go to next message
shahzad-ul-hasan
Messages: 600
Registered: August 2002
Senior Member
dear sir, pls help ,me how i can prevent the user from the charcter type input, but the field contain the number datatype.how i can prevnt these from number data , but the actual field contain the char datatype.
thx for help
Re: validation checks on the character [message #83812 is a reply to message #83795] Mon, 15 December 2003 03:19 Go to previous message
magnetic
Messages: 324
Registered: January 2003
Senior Member
if to_number(:block.fieldname)=:block.fieldname then
message('fieldvalue is number');
end if;
exception
when others then
message('field is not a number');
Previous Topic: File Dialog Box
Next Topic: List Box transfer control
Goto Forum:
  


Current Time: Sun Aug 14 23:20:03 CDT 2022