November 18th, 2003, 06:59 PM
Join Date: Sep 2003
Time spent in forums: 2 h 45 m 20 sec
Reputation Power: 11
I want to add a default employee in the each department if there is no employee in the department. I typed the following pl/sql behind the button and it works.
SELECT count(*) INTO count FROM emp
WHERE deptno = :dept.deptno;
if count=0 then
insert into emp (empno,ename,sal,deptno)
I dont know what is the problem in your form. can you please send me little bit more detail, like what is the relatioship beetween your table and how many constraints each table has?