| forms6i-urgent [message #80623] |
Tue, 22 October 2002 18:47  |
muralidhar
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;
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
|
|
|
|
| Re: forms6i-urgent [message #80629 is a reply to message #80623] |
Wed, 23 October 2002 03:30  |
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 |
Zaire
Messages: 36
Registered: October 2002
|
Member |
|
|
|
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
