Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HOST COMMAND

Status
Not open for further replies.

NITIN27

Programmer
Dec 11, 2003
24
IN
HI.

I want to run a winzip wizard through oracle forms and also want to make a zip file of any directory This all work i want to get it done through forms at Runtime I have tried to do this by HOST command

HOST(WINZIP32);

But it doesn't open a wizard of winzip

Pls. tell me how could i do this with a app. syntax

Happy New Year

Thanks in advance
 
Specify the full path of the item you want to run, and enclose it in single quotes.
 
HI,
I WANT TO MAKE A ZIP FILE OF A FOLDER FROM FORM AT RUNTIME

Example
FOLDER FOR WHICH BACKUP TO TAKE-'C:\LOGIWWW'
NAME OF ZIP FILE -'LOGISTORE ZIP FILE IN PATH -'C:\LOGI_BKP'


I HAVE WRITTEN THIS ON TRIGGER

(WHEN-BUTTON-PRESSED-TRIGGER)
DECLARE
DRP VARCHAR2(300);
BEGIN
DRP:='C:\PROGRAM FILES\WINZIP\WINZIP32'
HOST(DRP,SCREEN);
END;

I Hope u will understand my requirement

Thanks in Advance
 
What version of forms are you using? If you are using Forms 9i or deploying your form on the Web in version 6i then the HOST build-in will run on the server, not on the client.

So in your case, "c:\program files\winzip\winzip32" must exist in the server. Also the server must be running Windows, instead on any other O/S such as LINUX. In addition "winzip" will only access files on the server.

I've read somewhere that Oracle has released a library to allow Forms to manipulate objects (i.e files, programs, etc) on the client. Go to the Oracle web site and search for it.
 
Try this:
DRP:='"C:\PROGRAM FILES\WINZIP\WINZIP32"'

Long names should be double-quoted. To verify your command syntax before calling it through HOST try to launch it from command prompt.

Regards, Dima
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top