Home » Developer & Programmer » Forms » Restrict Numbers from entering.
Restrict Numbers from entering. [message #190088] Tue, 29 August 2006 04:36 Go to next message
marlon_loyolite
Messages: 66
Registered: July 2006
Member
Hi,
I need to the restrict the users entering NUMBERS in a control item of my screen which is primarily a CHARACTER item.

Any help could be useful.

Regards,
Marlon Loyolite.
Re: Restrict Numbers from entering. [message #190511 is a reply to message #190088] Thu, 31 August 2006 02:26 Go to previous messageGo to next message
jowahl
Messages: 82
Registered: May 2006
Member
i'd check it in the WHEN-VALIDATE-ITEM trigger:

DECLARE
    v_number NUMBER;
BEGIN
    SELECT TO_NUMBER(:BLOCK.ITEM)
    INTO   v_number;
EXCEPTION
    WHEN OTHERS THEN
         MESSAGE('Only Characters are allowed!');PAUSE;
         RAISE FORM_TRIGGER_FAILURE;
END;
Re: Restrict Numbers from entering. [message #191757 is a reply to message #190088] Fri, 08 September 2006 00:59 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: Restrict Numbers from entering. [message #191758 is a reply to message #191757] Fri, 08 September 2006 01:03 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at http://www.orafaq.com/forum/m/173919/67467/?srch=rtrim#msg_173919

David
Previous Topic: Web Forms Complete Reference
Next Topic: Calling Report from Menu (Oracle Forms 10g
Goto Forum:
  


Current Time: Fri Dec 02 18:23:37 CST 2016

Total time taken to generate the page: 0.15198 seconds