OraFAQ Forum: Forms » How to set dynamic path in oracle form?

Home » Developer & Programmer » Forms » How to set dynamic path in oracle form?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to set dynamic path in oracle form? [message #338820]

Wed, 06 August 2008 01:00

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.

Report message to a moderator

Re: How to set dynamic path in oracle form? [message #339129 is a reply to message #338820]

Wed, 06 August 2008 18:30

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.

Report message to a moderator