update column through report 6 [message #435459] |
Wed, 16 December 2009 06:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
asalam
Messages: 14 Registered: July 2009
|
Junior Member |
|
|
hi
can i update specific column through report run time.
for example
i have a report followup the documents , and i want to update these columns without go to form for update every document.
thankx
|
|
|
|
|
Re: update column through report 6 [message #435473 is a reply to message #435464] |
Wed, 16 December 2009 06:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I can't tell for Reports 6i, but - as 10g makes that possible, I *believe* that you can do that with the lower (6i) version too.
You'd do that in one of reports' triggers (such as AFTER REPORT or AFTER PARAMETER FORM or ...) or, if you want, write your own procedure (under the Program Units node) and call it from a trigger.
This may be an ordinary UPDATE statement, such asfunction AfterPForm return boolean is
begin
update test set val = to_char(sysdate, 'hh24:mi:ss');
commit;
return (TRUE);
end;
or, alternatively, use SRW built-in package:function AfterPForm return boolean is
begin
srw.do_sql('update test set val = to_char(sysdate, ''hh24:mi:ss'')');
commit;
return (TRUE);
end;
Or, create a stored procedure and call it from a report trigger.
There might be other options, but I can't think of any at the moment.
|
|
|
|
Re: update column through report 6 [message #435476 is a reply to message #435473] |
Wed, 16 December 2009 06:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
asalam
Messages: 14 Registered: July 2009
|
Junior Member |
|
|
little foot
as usual very fast reply
thank u
the user want to write ,so i can't imagine this case
but can i create button to open form contain the column and update it without closing report.
thankx
|
|
|