Home » Developer & Programmer » Forms » Post Text Item
- Post Text Item [message #79740] Sun, 07 July 2002 02:10 Go to next message
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;

Report message to a moderator

- Re: Post Text Item [message #79741 is a reply to message #79740] Sun, 07 July 2002 03:14 Go to previous message
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.

Report message to a moderator

Previous Topic: Re: FRM-40508 error solutions
Next Topic: LAST DML DATE ON A TABLE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 01 16:06:20 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.