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

Report message to a moderator

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');

Report message to a moderator

Previous Topic: File Dialog Box
Next Topic: List Box transfer control
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Aug 14 23:20:03 CDT 2022
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.