Home » Developer & Programmer » Forms » format trigger + placeholder column
format trigger + placeholder column [message #375491] Mon, 06 November 2000 09:29 Go to next message
David
Messages: 110
Registered: November 1998
Senior Member
Hello,

I have a repeating frame on a report. According to a value(ex: 15) , a total must be shown. Once the total is shown, it mustn't be repeated for other records even if the value is 15. I tried to accomplish this by using a format trigger and a placeholder column (to see if the total was already given), but I get the error "REP-1323 Cannot have ouput columns in format trigger".
The piece of code I use in the format trigger:
If value = 15 AND pc_tot = 'FALSE' THEN
pc_tot := 'TRUE'; <-- error on updating placeholder column
RETURN(true);
ELSE
RETURN(false);
END IF;

Can anybody give me a method to solve this problem? Thanks in advance.

D
Re: format trigger + placeholder column [message #375509 is a reply to message #375491] Thu, 09 November 2000 10:01 Go to previous message
Paul
Messages: 164
Registered: April 1999
Senior Member
The format trigger on the total field (PC_TOT) can just read:

IF :value = 15 THEN
RETURN true;
ELSE
RETURN false;
END IF;
Previous Topic: REP-0159 Message while running report from Forms6i
Next Topic: Updating value in format trigger
Goto Forum:
  


Current Time: Sun Mar 29 11:21:47 CDT 2020