Home » Developer & Programmer » Forms » forms6i-urgent
forms6i-urgent [message #80623] Tue, 22 October 2002 18:47 Go to next message
Messages: 13
Registered: September 2002
Junior Member
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 ticket_info IS
v_deptno dept.deptno%type;
v_dname dept.dname%type;

:control.carrier := v_dname;
UPDATE dept set dname = v_dname
WHERE deptno = :dept.deptno;
please help me,i have it to show it tommorrow
Re: forms6i-urgent [message #80629 is a reply to message #80623] Wed, 23 October 2002 03:30 Go to previous messageGo to next message
Lars Sjöström
Messages: 24
Registered: June 2001
Junior Member
YOu should really do this in the normal block with the table dept.

BUt I really do not clearly see what is wrong here.

If the code above is on the when-button-pressed trigger it should work. I think.
Re: forms6i-urgent [message #80642 is a reply to message #80623] Thu, 24 October 2002 15:14 Go to previous message
Messages: 36
Registered: October 2002
Cant see clearly whats the problem. Perhaps you're trying to update the table's record thats currently viewed in the form's block and there may be an exclusive lock on it somewhere.
Previous Topic: How to trap FRM-40350 in Forms
Next Topic: dynamic sql
Goto Forum:

Current Time: Sat Mar 02 12:05:11 CST 2024