i have written an update statement in forms.i am using one datablock
dept and a control block.i am calling the control block via the datablock when i click the deptno it will go to the control block.the dname should be updated for a particular deptno in the database when i enter data in control block. i have placed a text item and save button in controlblock.the dml i have written is
PROCEDURE save_ticket_info IS
:control.carrier := v_dname;
UPDATE dept set dname = v_dname
WHERE deptno = :dept.deptno;
please help me,i have it to show it tommorrow
Last edited by rao; 10-23-2002 at 12:45 AM.
If I understand the problem correctly, you could just assign
the database block with the new dname value:
dept.dname := v_dname;
Why is every question urgent?
Click Here to Expand Forum to Full Width