| check box and record insertion problem! [message #209752] |
Sun, 17 December 2006 09:33  |
oracle06
Messages: 36
Registered: December 2005
|
Member |
|
|
hello all,
I am facing problem.
1)I have two multiple data blocks with master-detail relationship,there are check boxes associated with each record.all check boxes reside in a cotrol block(non data base block)and I have set value when checked - Y,value when unchecked- N,and initial value - N it means at run time all check boxes should not be checked by default,but they are checked,and if will clik on check box then all turns to unmarked after this i select particular check box.how to solve this problem?
2)By randomly selecting the record using check box i have to insert these selected records in an another table on when button pressed.for this i am writting :-
BEGIN
IF CHECKBOX_CHECKED('BL_CTRL.CHK1')THEN
INSERT INTO DEPT_EMP VALUES(:DEPT.DEPTNO,
:DEPT.DNAME,
:DEPT.LOC,
:EMP.EMPNO,
:EMP.ENAME,
:EMP.JOB,
:EMP.MGR,
:EMP.HIREDATE,
:EMP.SAL,
:EMP.COMM,
:EMP.DEPARTMENT_ID);
END IF;
END;
but it is not working.after inserting these record in a table I have to remove it also.
plz guide me.
Thanks.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
