Home » Developer & Programmer » Forms » Updating value in format trigger
Updating value in format trigger [message #375490] Mon, 06 November 2000 09:28 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: Updating value in format trigger [message #375518 is a reply to message #375490] Tue, 14 November 2000 01:13 Go to previous message
usha elizabeth
Messages: 3
Registered: November 2000
Junior Member
Hi,
If you insist that you have to update at this point then you could use the following bit of code in the format trigger which should be sparingly used as oracle does not recommend the use of this package frequently for optimization reasons.
srw.do_sql('select '||'''TRUE'''||' into :pc_tot from dual');
Note : a space after 'select' and before 'into' is
mandatory.

assuming pc_tot is a parameter. This should help .
Previous Topic: format trigger + placeholder column
Next Topic: Urgent Please
Goto Forum:
  


Current Time: Fri Apr 03 06:26:55 CDT 2020