forms6i-urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: forms6i-urgent

  1. #1
    Join Date
    Jan 2002
    Posts
    111

    Question 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-23-2002 at 12:45 AM.

  2. #2
    Join Date
    Apr 2002
    Location
    Philippines
    Posts
    77
    hi,

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

    dept.dname := v_dname;

    hth.

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    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
  •  


Click Here to Expand Forum to Full Width