| help forms 6.0 [message #365981] |
Mon, 21 August 2000 20:52  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
