| Updating value in format trigger [message #375490] |
Mon, 06 November 2000 09:28  |
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  |
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 .
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
