forms6i-urgent

[rao]

Hi Gurus,

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
v_deptno dept.deptno%type;
v_dname dept.dname%type;

BEGIN
:control.carrier := v_dname;
UPDATE dept set dname = v_dname
WHERE deptno = :dept.deptno;
end;
please help me,i have it to show it tommorrow

[skid]

hi,

If I understand the problem correctly, you could just assign
the database block with the new dname value:

dept.dname := v_dname;

hth.

[stecal]

Why is every question urgent?