OraFAQ Forum: Forms » Stop End User to enter '?' character in text item

Home » Developer & Programmer » Forms » Stop End User to enter '?' character in text item

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

Stop End User to enter '?' character in text item [message #336095]

Thu, 24 July 2008 15:09

mhakimjavadi
Messages: 37
Registered: July 2008

Member

Hi,

I need to know what is the best way to program in oracle Form to stop user to enter '?' character in text item.

Thanks in advance for your advice.

Report message to a moderator

Re: Stop End User to enter '?' character in text item [message #336097 is a reply to message #336095]

Thu, 24 July 2008 15:22

szogu
Messages: 21
Registered: July 2008

Junior Member

A quick one, Use when-validate-item trigger, check text entered by using INSTR function

Regards,

Report message to a moderator

Re: Stop End User to enter '?' character in text item [message #336292 is a reply to message #336097]

Fri, 25 July 2008 09:38

mhakimjavadi
Messages: 37
Registered: July 2008

Member

Yes but if the value was wrong then I need to back to same field with massage. In this case I can not use GO_ITEM procedure in when validate item Trigger. Please advice?

Thanks

Report message to a moderator

Re: Stop End User to enter '?' character in text item [message #336295 is a reply to message #336292]

Fri, 25 July 2008 09:52

szogu
Messages: 21
Registered: July 2008

Junior Member

If when_validate_item trigger fails, user can not navigate to another field. So you do not need go_item to go to the same field. So if ? mark is entered, you should fail the when_validate_item trigger by using RAISE FORM_TRIGGER_FAILURE.

Report message to a moderator

Re: Stop End User to enter '?' character in text item [message #339240 is a reply to message #336295]

Thu, 07 August 2008 02:25

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

'Go_item' is an illegal command in the 'when-validate-item' trigger so you don't have to worry about issuing that command.

David

Report message to a moderator

Previous Topic:	size of ole
Next Topic:	How to pass parameters from form to report?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 27 17:11:00 CDT 2026