OraFAQ Forum: Forms » format trigger + placeholder column

Home » Developer & Programmer » Forms » format trigger + placeholder column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

format trigger + placeholder column [message #375491]

Mon, 06 November 2000 09:29

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

Report message to a moderator

Re: format trigger + placeholder column [message #375509 is a reply to message #375491]

Thu, 09 November 2000 10:01

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;

Report message to a moderator

Previous Topic:	REP-0159 Message while running report from Forms6i
Next Topic:	Updating value in format trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 31 16:40:26 CST 2025