OraFAQ Forum: Forms » Restrict Numbers from entering.

Home » Developer & Programmer » Forms » Restrict Numbers from entering.

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

Restrict Numbers from entering. [message #190088]

Tue, 29 August 2006 04:36

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.

Report message to a moderator

Re: Restrict Numbers from entering. [message #190511 is a reply to message #190088]

Thu, 31 August 2006 02:26

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;

Report message to a moderator