OraFAQ Forum: Forms » open exe file from a button

Home » Developer & Programmer » Forms » open exe file from a button (forms 10g)

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

open exe file from a button [message #279790]

Sat, 10 November 2007 05:19

emadnabil
Messages: 179
Registered: August 2007

Senior Member

hii all

i want to open an exe file by pressing on a button on my form

is there any command to open an exe file

Report message to a moderator

Re: open exe file from a button [message #279792 is a reply to message #279790]

Sat, 10 November 2007 05:29

alijeyan
Messages: 184
Registered: January 2007
Location: IRAN

Senior Member

in Trigger WHEN_BUTTON_PRESSED
test this :

 DECLARE
	APPID PLS_INTEGER;
BEGIN
---- Open Calculator when button pressed
APPID :=DDE.APP_BEGIN ('\path\CALC.EXE',DDE.APP_MODE_Maximized);
END;

ALI

Report message to a moderator

Re: open exe file from a button [message #279801 is a reply to message #279792]

Sat, 10 November 2007 08:47

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Additionally, and if applicable to your situation: there's a HOST built-in which can be used to execute operating system commands:

host('c:\windows\system32\calc.exe');

Report message to a moderator

Re: open exe file from a button [message #279863 is a reply to message #279790]

Sun, 11 November 2007 03:12

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Thanks for your replies

i used the host command
but when i run the application and press the button that execute the command host it opens the exe file on the server side not client side

Report message to a moderator

Re: open exe file from a button [message #279864 is a reply to message #279863]

Sun, 11 November 2007 03:16

alijeyan
Messages: 184
Registered: January 2007
Location: IRAN

Senior Member

Hi

Please Use My Post .

ALI

Report message to a moderator

Re: open exe file from a button [message #279871 is a reply to message #279790]

Sun, 11 November 2007 05:08

emadnabil
Messages: 179
Registered: August 2007

Senior Member

I tried your post
but still not working
the same problem still exists

Report message to a moderator

Re: open exe file from a button [message #279886 is a reply to message #279790]

Sun, 11 November 2007 08:06

emadnabil
Messages: 179
Registered: August 2007

Senior Member

I still have the same problem
i cannot see the exe file running on the client side
it runs only on the server side

Report message to a moderator

Re: open exe file from a button [message #280528 is a reply to message #279886]

Wed, 14 November 2007 00:10

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Try using the 'client_host' command.

David

Report message to a moderator

Re: open exe file from a button [message #281734 is a reply to message #279790]

Mon, 19 November 2007 02:57

emadnabil
Messages: 179
Registered: August 2007

Senior Member

thanks for your reply

but i used client_host
in this command

client_host('\\192.168.2.206\D$\SDSSREPORTS.EXE');

and in compilation it give me:
identifier 'client_host' must be declared

Report message to a moderator

Re: open exe file from a button [message #281781 is a reply to message #281734]

Mon, 19 November 2007 05:21

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Client_host is part of WebUtil.

MHE

Report message to a moderator

Re: open exe file from a button [message #281806 is a reply to message #279790]

Mon, 19 November 2007 06:33

emadnabil
Messages: 179
Registered: August 2007

Senior Member

thanks for your reply

is this syntax command correct
client_host('\\192.168.2.206\D$\SDSSREPORTS.EXE');

do i need to a declartion
i got an error of invalid identifier
when compile this code

Report message to a moderator

Re: open exe file from a button [message #281814 is a reply to message #281806]

Mon, 19 November 2007 06:51

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You need to attach webutil.pll to use CLIENT_HOST. The link I posted provides more information. I never used client_host myself but it's possible that you need to do some more tweaking (like import a Java class).

MHE

Report message to a moderator

Re: open exe file from a button [message #281844 is a reply to message #279790]

Mon, 19 November 2007 08:45

emadnabil
Messages: 179
Registered: August 2007

Senior Member

I tried your post
but it when i run the application it gives me a message of "please achnowledge"

and don't continue openning the file

Report message to a moderator

Re: open exe file from a button [message #281890 is a reply to message #281844]

Mon, 19 November 2007 18:12

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please search this forum for 'client_host' to get an idea of how other people have handled this problem.

Also have a look at 'dde app_begin'.

David

Report message to a moderator

Re: open exe file from a button [message #282179 is a reply to message #279790]

Wed, 21 November 2007 01:28

emadnabil
Messages: 179
Registered: August 2007

Senior Member

thanks for your reply

'DDE.APP_BEGIN' is openning the text file on application server
not on the client PC

and again when i used 'client_host' but it when i run the application it gives me a message of "please achnowledge" in the runtime

Report message to a moderator

Re: open exe file from a button [message #282407 is a reply to message #282179]

Wed, 21 November 2007 23:02

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please post your code.

Also confirm which version of Forms that you are running.

David

Report message to a moderator

Re: open exe file from a button [message #282469 is a reply to message #279790]

Thu, 22 November 2007 01:36

emadnabil
Messages: 179
Registered: August 2007

Senior Member

I am using forms Version 10.1.2.0.2

the code is on trigger "WHEN-TREE-NODE-ACTIVATED"

iF :INTRO.TREE_VAL=33	then 
DECLARE 
U  VARCHAR2(10);
BEGIN 
  SELECT S.USER_ID INTO U
  FROM FND_USER S
  WHERE S.USER_NAME=:Global.uusername;

  INSERT INTO REP_HISTORY VALUES ('Daily Sales Report.rdf',U,:Global.uusername,SYSDATE);
  COMMIT ;
  client_host('\\192.168.2.206\D$\SDSSREPORTS.EXE');

end;

end if;

when i run the application it gives me a message of "please achnowledge" in the runtime

Report message to a moderator

Re: open exe file from a button [message #282637 is a reply to message #282469]

Thu, 22 November 2007 19:15

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Try "client_host('CMD /C \\192.168.2.206\D$\SDSSREPORTS.EXE');"

David

Report message to a moderator

Re: open exe file from a button [message #282917 is a reply to message #279790]

Sun, 25 November 2007 01:38

emadnabil
Messages: 179
Registered: August 2007

Senior Member

thanks for your reply

i made a form with one button
when pressing on this button it should execute the command of client_host

but i got this errors

the webutil object group is not available in this form
web util cannot work

webutil error : oracle.forms.webutil.host.hostbean not found
WEBUITL_HOST. execute will not work

Report message to a moderator