Home » Developer & Programmer » Forms » Stop End User to enter '?' character in text item
Stop End User to enter '?' character in text item [message #336095] Thu, 24 July 2008 15:09 Go to next message
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.
Re: Stop End User to enter '?' character in text item [message #336097 is a reply to message #336095] Thu, 24 July 2008 15:22 Go to previous messageGo to next message
szogu
Messages: 21
Registered: July 2008
Junior Member
A quick one, Use when-validate-item trigger, check text entered by using INSTR function

Regards,
Re: Stop End User to enter '?' character in text item [message #336292 is a reply to message #336097] Fri, 25 July 2008 09:38 Go to previous messageGo to next message
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
Re: Stop End User to enter '?' character in text item [message #336295 is a reply to message #336292] Fri, 25 July 2008 09:52 Go to previous messageGo to next message
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.
Re: Stop End User to enter '?' character in text item [message #339240 is a reply to message #336295] Thu, 07 August 2008 02:25 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: size of ole
Next Topic: How to pass parameters from form to report?
Goto Forum:
  


Current Time: Wed Dec 07 06:59:17 CST 2016

Total time taken to generate the page: 0.25551 seconds