Home » Developer & Programmer » Forms » How to get the control back to form from the command prompt after opening a web page usin HOST comnd (D2K 6i,windows 2000)
How to get the control back to form from the command prompt after opening a web page usin HOST comnd [message #357968] Fri, 07 November 2008 07:33 Go to next message
rajshekarcpsetty
Messages: 7
Registered: November 2008
Location: Bangalore
Junior Member
I have opened a web page using the HOST command in the form builder module. The problem is that, the control is not returned to the form after the web page is opened thru HOST. Is there any way to get the control back to the form while the web page is still open?

If not, is there any better way to make an active web link on a form ( Like embedding a web link)other than using host?

Suggestions and comments are much appreciated.

Thanks & regards,
-Raj.

[Updated on: Fri, 07 November 2008 08:19]

Report message to a moderator

Re: How to get the control back to form from the command prompt after opening a web page usin HOST c [message #358178 is a reply to message #357968] Mon, 10 November 2008 00:29 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you read the documentation for the 'host' command? Have you searched this forum for 'host' and looked at the examples?

David
Re: How to get the control back to form from the command prompt after opening a web page usin HOST c [message #358218 is a reply to message #358178] Mon, 10 November 2008 02:55 Go to previous messageGo to next message
rajshekarcpsetty
Messages: 7
Registered: November 2008
Location: Bangalore
Junior Member
Hi David,

Thank you for your response.

I did search for Host commands in the forum but could not find a relevant example.

I did read the help doc. in the form builder about host.
For the screen action part of host command there is a 'no parameter' mentioned in the help. But I could not incorporate that in my code. Its giving error.

If you have already come across such an instance kindly post me the direct link to that.

Thank you once again.

With warm regards,
-Raj.

[Updated on: Mon, 10 November 2008 02:58]

Report message to a moderator

Re: How to get the control back to form from the command prompt after opening a web page usin HOST c [message #358535 is a reply to message #358218] Tue, 11 November 2008 18:17 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What about the 'no_prompt' and the 'no_screen' options? Did they do anything different for you?

David
Re: How to get the control back to form from the command prompt after opening a web page usin HOST c [message #358619 is a reply to message #358535] Tue, 11 November 2008 23:45 Go to previous messageGo to next message
rajshekarcpsetty
Messages: 7
Registered: November 2008
Location: Bangalore
Junior Member
I did use no_promt and no_screen options, but the web page wont be seen though it is invoked. So I dont think we should use no_screen or no_promt options while invoking a web page.

And also when they are used, the control will never return back to the form module as we wont be able to see the web page so that we can close it. It appears as though the form is hung.

Is there any better way ( Some inbuilt procedure) in Oracle to invoke a web page from forms?

Thanks & regards,
-Raj.
Re: How to get the control back to form from the command prompt after opening a web page usin HOST c [message #358623 is a reply to message #358619] Tue, 11 November 2008 23:54 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please post your code. Do you use 'cmd' at the beginning of your command?

David
Re: How to get the control back to form from the command prompt after opening a web page usin HOST c [message #358626 is a reply to message #358623] Wed, 12 November 2008 00:09 Go to previous messageGo to next message
rajshekarcpsetty
Messages: 7
Registered: November 2008
Location: Bangalore
Junior Member
No I havent used cmd....

declare
mpath varchar2(200);
mhttp_add varchar2(200);
mfile_path varchar2(200);
begin
select help_path,'http://www.uttarainfo.com/' into mpath,mhttp_add from email;
mpath := '"'||mpath||'\iexplore.exe"';
host(mpath ||' '||mhttp_add);
end;

-Raj
Re: How to get the control back to form from the command prompt after opening a web page usin HOST c [message #358629 is a reply to message #358626] Wed, 12 November 2008 00:21 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Searching 'host cmd' returned http://www.orafaq.com/forum/m/342931/67467/?srch=host+cmd#msg_342931 and http://www.orafaq.com/forum/m/285230/67467/?srch=host+cmd#msg_285230

David
Re: How to get the control back to form from the command prompt after opening a web page usin HOST c [message #364524 is a reply to message #357968] Tue, 09 December 2008 00:14 Go to previous message
rajshekarcpsetty
Messages: 7
Registered: November 2008
Location: Bangalore
Junior Member
Hi,

It was a wrong idea to use Host to invoke a web page from forms 6i.
I used dde package and it works fine.

DECLARE
AppID PLS_INTEGER;
BEGIN
AppID := DDE.App_Begin('c:\iexplore.http://in.f76.mail.yahoo.com/',
DDE.App_Mode_Maximized);
END;

Use it... Its cool...

Thank you!

-Raj.
Previous Topic: 2 questions about List Of Value and how to make sequence
Next Topic: webutil_file.Directory_List
Goto Forum:
  


Current Time: Sun Dec 11 02:26:41 CST 2016

Total time taken to generate the page: 0.09628 seconds