Home » Developer & Programmer » Forms » when list changed (6i 10g)
when list changed [message #683252] Sat, 19 December 2020 03:34 Go to next message
Messages: 596
Registered: August 2002
Senior Member
dear all
i want to perform trigger when_list_changed. here is the code
if :na = 'ADD' then
end if;
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 269 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
Messages: 596
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: Tue Nov 30 04:04:48 CST 2021