OraFAQ Forum: Forms » opening pdf file

Home » Developer & Programmer » Forms » opening pdf file (oracle forms 11g)

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

opening pdf file [message #625776]

Tue, 14 October 2014 03:32

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

respected sir

i want to open pdf file store at a particular location
by pressing a button on form.i use this code its running fine.

declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin('C:\Program Files (x86)\Adobe\Acrobat 11.0\Acrobat\Acrobat.exe C:\Users\Administrator\Desktop\AllDiagrams\USR3.PDF,DDE.APP_MODE_Maximized);
exception when others then 
MESSAGE('NO SUCH DIAGRAM..PLEASE CHECK DIAGRAM NAME');
MESSAGE('NO SUCH DIAGRAM..PLEASE CHECK DIAGRAM NAME');
end;

but i dont want to give the pdf name directly.i want it from the item named diagram.
if i enter the values USR3 in item diagram it should open the USR3.PDF.for this i tried

declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin('C:\Program Files (x86)\Adobe\Acrobat 11.0\Acrobat\Acrobat.exe C:\Users\Administrator\Desktop\AllDiagrams'||:RING.diagram||'.PDF',DDE.APP_MODE_Maximized);
exception when others then 
MESSAGE('NO SUCH DIAGRAM..PLEASE CHECK DIAGRAM NAME');
MESSAGE('NO SUCH DIAGRAM..PLEASE CHECK DIAGRAM NAME');
end;

its not working.

kindly please help.
thanks in advance.

Report message to a moderator

Re: opening pdf file [message #625785 is a reply to message #625776]

Tue, 14 October 2014 04:08

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Use a message to check that the parameter you're passing to app_begin has the value you think it does.
I suspect you're missing a \.

Report message to a moderator

Re: opening pdf file [message #625788 is a reply to message #625785]

Tue, 14 October 2014 04:26

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

thank you very much sir that was the problem.
thanks again.

sir if i want to give server path so that the clients can
access this pdf files from server,how should i give the path.

thanks.

[Updated on: Tue, 14 October 2014 04:37]

Report message to a moderator

Re: opening pdf file [message #625789 is a reply to message #625788]

Tue, 14 October 2014 04:28

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Whenever you construct a dynamic string you should display the string to check it's actually the value you think it is. It's a lot quicker than posting questions on a forum.

Report message to a moderator

Re: opening pdf file [message #625791 is a reply to message #625789]

Tue, 14 October 2014 04:53

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

sir if i want to give server path so that the clients can
access this pdf files from server,how should i give the path.

Report message to a moderator

Re: opening pdf file [message #625793 is a reply to message #625791]

Tue, 14 October 2014 05:05

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Web server or DB server?

Either way you want be using App_Begin.
If it's on the web server then you use web.show_document. I'm not sure what you use if it's on the DB.

Report message to a moderator

Re: opening pdf file [message #625795 is a reply to message #625793]

Tue, 14 October 2014 05:18

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

That should have been
Either way you don't want to be using App_Begin.

[Updated on: Tue, 14 October 2014 05:19]

Report message to a moderator

Previous Topic:	FRM-91116:Internal Error:Oracle*Image startup failure
Next Topic:	for general ledger coding in form 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 18:53:04 CDT 2024