Home » Developer & Programmer » Reports & Discoverer » update column through report 6
update column through report 6 [message #435459] Wed, 16 December 2009 06:12 Go to next message
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 #435460 is a reply to message #435459] Wed, 16 December 2009 06:15 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
did you try that ?Using reports?
If so then whats the result?

sriram Smile
Re: update column through report 6 [message #435464 is a reply to message #435460] Wed, 16 December 2009 06:19 Go to previous messageGo to next message
asalam
Messages: 14
Registered: July 2009
Junior Member
no i did not because this is the user requirements,
so i try to search but i did not find solution
so i decided to ask the experts here

bye
Re: update column through report 6 [message #435473 is a reply to message #435464] Wed, 16 December 2009 06:41 Go to previous messageGo to next message
Littlefoot
Messages: 20827
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 as
function 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 #435475 is a reply to message #435473] Wed, 16 December 2009 06:45 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
sorry for the late reply....

IT will work on report 6i too.

sriram Smile
Re: update column through report 6 [message #435476 is a reply to message #435473] Wed, 16 December 2009 06:45 Go to previous message
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
Previous Topic: call report in forms oracle 10g
Next Topic: rep-1439 error while calling one report from another report
Goto Forum:
  


Current Time: Wed Sep 28 22:53:48 CDT 2016

Total time taken to generate the page: 0.07019 seconds