| how do i validate primary key from forms [message #87553] |
Sat, 15 January 2005 03:13  |
abhi
Messages: 16
Registered: September 1999
|
Junior Member |
|
|
suppose i have deptno, dname and loc in my table
i want to validate whether my deptno is already existed or not at item level of deptno before saving it
in which trigger i should write..and how do i validate.
|
|
|
|
| Re: how do i validate primary key from forms [message #87561 is a reply to message #87553] |
Sun, 16 January 2005 04:17  |
Just John
Messages: 69
Registered: November 2004
|
Member |
|
|
Look at the PRE_ triggers (e.g.PRE_INSERT, PRE_UPDATE) but also consider KEY_COMMIT.
e.g. as for KEY_COMMIT
----------------------
FOR i IN (SELECT deptno
FROM dept
WHERE deptno = :dept.deptno) LOOP;
MESSAGE('Duplicate');
RAISE FORM_TRIGGER_RECORD;
END;
DO_KEY('COMMIT_FORM');
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
