Home » Developer & Programmer » Forms » help forms 6.0
help forms 6.0 [message #365981] Mon, 21 August 2000 20:52 Go to next message
randy gui
Messages: 1
Registered: August 2000
Junior Member
I have an application on forms 6.0.
I need to input a value in a text field in a form. There are only 3 valid values for this field. I have a when validate trigger written for this validation.
Also there is a next action button that is present. If I enter a wrong value and then hit the next action button error message pops up saying that the value entered is not valid.When I acknowledge the same the message keeps coming up again and again.It goes into a infinite loop. By trial I found that it does so for the number of times as the number of records present in the form. I need it to exit out after giving the error message once only.
Any suggestions / help is welcome please.
Re: help forms 6.0 [message #365983 is a reply to message #365981] Mon, 21 August 2000 22:50 Go to previous message
M. Abu-Khalid
Messages: 3
Registered: August 2000
Junior Member
Try the following
in trigger " when-validate-item"
if the_entered_value not in (your range) then
write your error message and don't forget to type
"raise form_trigger_failure" after that to stop the
continuation of process..

end if;

I hope this will help
Previous Topic: MyOwnMenu&Smartbar
Next Topic: Translation Builder
Goto Forum:

Current Time: Tue May 21 17:25:44 CDT 2024