OraFAQ Forum: Forms » enter only characters and . and

Home » Developer & Programmer » Forms » enter only characters and . and _ (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

enter only characters and . and _ [message #173791]

Wed, 24 May 2006 07:58

ranisri321
Messages: 22
Registered: March 2006
Location: hyderabad

Junior Member

iam doing project.in that i have one textitem for ex ename.
the client wants ename should accepts only alphabets and dot(.) and hipen(-)is there any code for this.
if u have pls send me
its very urgent

Report message to a moderator

Re: enter only characters and . and _ [message #173799 is a reply to message #173791]

Wed, 24 May 2006 08:29

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

Hi

You Can Use INSTR FUN fro this.
Google Will Help You About Instr.

ASHish...

Report message to a moderator

Re: enter only characters and . and _ [message #173919 is a reply to message #173799]

Thu, 25 May 2006 04:40

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

djmartin has provided a very good solution in this post.

http://www.orafaq.com/forum/m/173262/67693/#msg_173262

Just you nees to add '.' and '-' in the code.

You code will be like

begin
   if rtrim (upper (:BLOCK_NAME.ITEM_NAME), ' ABCDEFGHIJKLMNOPQRSTUVWXYZ-.') is not null then
      message ('The entry is not allowed');
      raise form_trigger_failure;
   end if;
end;

regards.

Report message to a moderator

Previous Topic:	Differentiating ENTER/TAB key
Next Topic:	how use sumry column in form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:28:32 CDT 2024