Home » Developer & Programmer » Forms » How to set dynamic path in oracle form?
How to set dynamic path in oracle form? [message #338820] Wed, 06 August 2008 01:00 Go to next message
reenapatel
Messages: 11
Registered: July 2008
Junior Member
Hello,

I am using Oracle Form 6i. I have created pdf file from oracle report. On view button, I have written:

host('C:\Program Files\Adobe\Reader 8.0\Reader\AcroRd32.exe C:\dailypending.pdf');

My Question is:
I dont want to set this path on every machine. I want to set its dynamic path so that on which even I machine, I run the applicaiton, it will directly find AcroRd32.exe from any drive either C: or D: or anything else...

And another thing is:
It might be Acrobat Reader 9.0 or 8.0 whatever version will be installed on client machine...I want to set path according to that..So that whatever version it would be, it doesnt affect the application...


I want to set path according to above mentioned problems.

Can anyone please help me??

Thanks.
Re: How to set dynamic path in oracle form? [message #339129 is a reply to message #338820] Wed, 06 August 2008 18:30 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Create a function that opens the file to test if the directory/file specified is correct. This logic is not as good as windows program searching, you have to specify all possible directory and filename in order to open the correct file.
Re: How to set dynamic path in oracle form? [message #339635 is a reply to message #338820] Fri, 08 August 2008 00:49 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you tried just calling "host('AcroRd32.exe C:\dailypending.pdf');"?

David
Re: How to set dynamic path in oracle form? [message #339652 is a reply to message #339635] Fri, 08 August 2008 01:24 Go to previous messageGo to next message
reenapatel
Messages: 11
Registered: July 2008
Junior Member
Thanks for your reply..

I have solved my this query by using rundll32.exe url.dll in HOST()...

And its working properly...

icon4.gif  Re: How to set dynamic path in oracle form? [message #506577 is a reply to message #339652] Tue, 10 May 2011 01:19 Go to previous message
romin
Messages: 2
Registered: May 2011
Junior Member
How have you set rundll.exr in host ?
Can you give me systex ?
Previous Topic: How to send automated email from Oracle Form [merged by jd]
Next Topic: Help with Triggers V2
Goto Forum:
  


Current Time: Sat Dec 03 01:35:39 CST 2016

Total time taken to generate the page: 0.07959 seconds