OraFAQ Forum: Forms » Regarding WHEN_VALIDATE

Home » Developer & Programmer » Forms » Regarding WHEN_VALIDATE_ITEM TRIGGER

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

Regarding WHEN_VALIDATE_ITEM TRIGGER [message #146806]

Mon, 14 November 2005 00:27

narendrakumarkm
Messages: 8
Registered: November 2005

Junior Member

hi,

I need to write a trigger WHEN_VALIDATE_ITEM TRIGGER that validates the two text fields.If the combination of text fields already exists,then the trigger should be raised.

I am new to this and finding problem in this.Plz provide me some solutions

Report message to a moderator

Re: Regarding WHEN_VALIDATE_ITEM TRIGGER [message #146807 is a reply to message #146806]

Mon, 14 November 2005 00:41

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

modify this code as per your need and add is to when-validate-item trigger of the second field

declare
cnt number;
begin
select count(*)
into cnt
from scott.emp
where ename = :emp.ename and
job = :emp.job ;

if cnt >= 1 then
messaGE('COMBINATION ALREADY EXISTS ');
RAISE FORM_TRIGGER_FAILURE;
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
END;

correct me if i am wrong

Report message to a moderator

Re: Regarding WHEN_VALIDATE_ITEM TRIGGER [message #147004 is a reply to message #146807]

Tue, 15 November 2005 04:03

narendrakumarkm
Messages: 8
Registered: November 2005

Junior Member

thanx very much 4 u r reply. It was very helpful.

But I have another query.

My form is of master detail.

Before inserting values into the table, the two field combination must be checked.If user enters a value in text field in a detail block and once again user enters same value
for the next text item. The combination values are repeated now.So before inserting I need to write WHEN_VALIDATE_ITEM trigger for this.

So i am stuck with this,so plz if you know this then let me know about it.

THanks for your solution

Report message to a moderator

Re: Regarding WHEN_VALIDATE_ITEM TRIGGER [message #147005 is a reply to message #146807]

Tue, 15 November 2005 04:04

narendrakumarkm
Messages: 8
Registered: November 2005

Junior Member

No Message Body

Report message to a moderator

Previous Topic:	Dynamic LOV !! Forms Guru's Please Help
Next Topic:	Returning to different block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:46:17 CDT 2024