Regarding Key-next and When-validate-itemhttp://www.orafaq.com/forum/./mv/msg/57988/155829/#msg_155829
Suppose if I have defined two triggers Key-next and When-validate-item on the same item.

If my key-next is going to fire first and When-validate-item later
how can the validation happen if I write a code like go_item('XXXX')
in my Key-next.Does it mean that if u write a code in key-next to jump to some other item, no validation takes pLace?

Please explain it to me as it is the most frequently asked Quest in Interview.

Regads
srini...]]>srinivasocp2006-01-19T00:34:52-00:00Re: Regarding Key-next and When-validate-itemhttp://www.orafaq.com/forum/./mv/msg/57988/155840/#msg_155840
David]]>djmartin2006-01-19T03:04:19-00:00Re: Regarding Key-next and When-validate-itemhttp://www.orafaq.com/forum/./mv/msg/57988/155910/#msg_155910
Can u please tell me which one will fire first and what happens when my Key-next is taking me to next-item and how
does the when-validate-item take place.

]]>shareef.hiasat2012-11-05T12:31:33-00:00Re: Regarding Key-next and When-validate-itemhttp://www.orafaq.com/forum/./mv/msg/57988/570100/#msg_570100
restricted procedure in that trigger.

However, what does your statement have to do with the question discussed in this topic?]]>Littlefoot2012-11-05T17:54:27-00:00Re: Regarding Key-next and When-validate-itemhttp://www.orafaq.com/forum/./mv/msg/57988/570133/#msg_570133
cookiemonster2012-11-05T23:59:50-00:00Re: Regarding Key-next and When-validate-itemhttp://www.orafaq.com/forum/./mv/msg/57988/570158/#msg_570158
I have came across with the problem that you are facing the way i solved that issue, i just delete the when validate trigger and wrote condition on key-next-item then it just work out and i got relief finally from ths problem
Example of simple code on key next item
if :a>0 then
message('abc ');
else
go_item('XXXX');
end if;

thanx
]]>rajput_106@hotmail.com2012-11-06T07:51:07-00:00Re: Regarding Key-next and When-validate-itemhttp://www.orafaq.com/forum/./mv/msg/57988/570181/#msg_570181
You need to use a validate trigger for that.]]>cookiemonster2012-11-06T12:22:08-00:00Re: Regarding Key-next and When-validate-itemhttp://www.orafaq.com/forum/./mv/msg/57988/570185/#msg_570185
Littlefoot2012-11-06T12:58:59-00:00Re: Regarding Key-next and When-validate-itemhttp://www.orafaq.com/forum/./mv/msg/57988/570228/#msg_570228
rajput_106@hotmail.com2012-11-07T06:35:07-00:00Re: Regarding Key-next and When-validate-itemhttp://www.orafaq.com/forum/./mv/msg/57988/570277/#msg_570277
rajput_106@hotmail.com wrote on Wed, 07 November 2012 06:35

and after jumping that item then valdate trigger fire at that time that cause no meaning (it is in query mode )

]]>cookiemonster2012-11-07T14:09:04-00:00Re: Regarding Key-next and When-validate-itemhttp://www.orafaq.com/forum/./mv/msg/57988/590952/#msg_590952
I have similar problem. Pls give me some inputs to achive this result.

There is a multi record block in my form. When user tries to enter duplicate data in this block and tab out from the last field i.e. end_date then a pop-up should be raised.
"This is duplicate record, you want to keep it?" It has 2 buttons, Yes or No.

When user clicks "Yes" button the data should be saved immediately(committed).
Since i put this validation in when-validate-item of that end_date filed i can't use commit-form; Is there is any work around to achive this ? Pls suggest some ideas.