| Post Text Item [message #79740] |
Sun, 07 July 2002 02:10  |
shofi
Messages: 9
Registered: October 2001
|
Junior Member |
|
|
Hi friends,
I want to update my database from a form by this procedure given below. But it is not updating under a post test item. Can anybody help me?
declare
bs basic_status.basic%type;
bi basic_status.id%type;
begin
update overtimeal
set total = nvl(overtime,0)/bs*12/100+nvl(arrear,0)
-nvl(adjustment,0)
where id=bi;
end;
|
|
|
|
| Re: Post Text Item [message #79741 is a reply to message #79740] |
Sun, 07 July 2002 03:14  |
Subhash
Messages: 105
Registered: October 2001
|
Senior Member |
|
|
|
You have not issued a commit; Also u can't give commit in 'Post-Text-Item' trigger. Try this procedure in 'Key-Next-Item' triger or use a 'timer' for achieving the same with ur trigger.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
