| when list changed [message #683252] |
Sat, 19 December 2020 03:34  |
shahzad-ul-hasan
Messages: 643
Registered: August 2002
|
Senior Member |
|
|
dear all
i want to perform trigger when_list_changed. here is the code
declare
begin
if :na = 'ADD' then
:aa:=-nvl(:rdsp,0)+nvl(:rnsp,0);--1
:bb:=nvl(:rdcyl,0);--2
:cc:=nvl(:rdax,0);--3
:dd:=-nvl(:ldsp,0)+nvl(:lnsp,0);--4
:ee:=nvl(:ldcyl,0);--5
:ff:=nvl(:ldax,0);--6
:rncyl:=0.00;--7
:rnax:=0.00;--8:
lncyl:=0.00;--9
:lnax:=0.00;
else
:rnsp:=nvl(:aa,0);
:rncyl:=nvl(:rdcyl,0);
:rnax:=nvl(:rdax,0);
:lnsp:=nvl(:dd,0);
:lncyl:=nvl(:ldcyl,0);
:lnax:=nvl(:ldax,0);
end if;
end;
[img]/foru/forum/fa/14443/0/[/img]
if i use list value add it will only add in comment line (1, 2, 3) one time.but when i changed the list too many times it adds the value many time. how i can restrict to add only time based on list value.
please see the attached file. the red color line contains the required result. Please advised how i can get the required output.
-
Attachment: 2.jpg
(Size: 17.33KB, Downloaded 1653 times)
[Updated on: Sat, 19 December 2020 23:54] Report message to a moderator |
|
|
|
| Re: when list changed [message #683262 is a reply to message #683252] |
Sun, 20 December 2020 12:58  |
shahzad-ul-hasan
Messages: 643
Registered: August 2002
|
Senior Member |
|
|
|
I have list value which has two values like(NEAR,NEAR-ADD). I have a table which have six columns like (a,b,c,d,e,f). when I create new record it will add NEAR-ADD in fields values in (a )column and (d)column. When I select value NEAR it will perform +/- function on a,b columns but when I select value NEAR-ADD it will show the previous value which I put at the time of insert. No change in it. Please advised.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
