Home » Developer & Programmer » Forms » when list changed (6i 10g)
when list changed [message #683252] Sat, 19 December 2020 03:34 Go to next message
shahzad-ul-hasan
Messages: 580
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]
pls view the attached file./foru/forum/fa/14442/0/
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 109 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 Go to previous message
shahzad-ul-hasan
Messages: 580
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.
Previous Topic: connect error in oracle forms 6i
Next Topic: Error message after the backup process is complete
Goto Forum:
  


Current Time: Sun Apr 18 23:03:12 CDT 2021