-
forms6i
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
Last edited by rao; 10-22-2002 at 11:45 PM.
-
hi,
If I understand the problem correctly, you could just assign
the database block with the new dname value:
dept.dname := v_dname;
hth.
-
Why is every question urgent?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|