OraFAQ Forum: Forms » How to check whether the folder exist in computer using oracle form 6i

Home » Developer & Programmer » Forms » How to check whether the folder exist in computer using oracle form 6i (Windows XP, Oracle form 6i)

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

How to check whether the folder exist in computer using oracle form 6i [message #603115]

Wed, 11 December 2013 08:41

dark_prince
Messages: 121
Registered: June 2013
Location: India

Senior Member

Is there a way to check whether the folder exist in my computer using oracle form...
Kinda like if abc named folder does not exist in my computer then it should be created if it is exists then pqr named folder should get created...
Can anyone please tell me how to do it...

Report message to a moderator

Re: How to check whether the folder exist in computer using oracle form 6i [message #603136 is a reply to message #603115]

Wed, 11 December 2013 10:32

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

Senior Member
Account Moderator

I never tried that so I don't have an answer. However, scroll to the end of this page (two suggestions).

Or, write a DOS batch script according to this discussion which would use DOS "IF EXIST" command; you'd call that script with Forms' HOST built-in.

Report message to a moderator

Re: How to check whether the folder exist in computer using oracle form 6i [message #603142 is a reply to message #603136]

Wed, 11 December 2013 12:30

dark_prince
Messages: 121
Registered: June 2013
Location: India

Senior Member

Hi i tried second one but its giving compilation error like encountered the symbol filename when expecting some symbol like . , ()

Report message to a moderator

Re: How to check whether the folder exist in computer using oracle form 6i [message #603143 is a reply to message #603142]

Wed, 11 December 2013 12:34

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Well, then you did it wrong but only you know what command you used.

Report message to a moderator

Re: How to check whether the folder exist in computer using oracle form 6i [message #603154 is a reply to message #603143]

Wed, 11 December 2013 15:13

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

have you solved your problem otherwise allow me to do its easy logic will check "FOLDER" Exist in your computer if exist will message appear "FOLDER" is already Exist ELSE "FOLDER" will create automatically.

Regard
mughal

Report message to a moderator

Re: How to check whether the folder exist in computer using oracle form 6i [message #603234 is a reply to message #603143]

Thu, 12 December 2013 07:57

dark_prince
Messages: 121
Registered: June 2013
Location: India

Senior Member

Hii i used following coding to create folder


BEGIN
   IF EXIST 'D:\2013'
   THEN
       HOST ('MD '||'D:\2014', NO_SCREEN);
   ELSE
       HOST ('MD '||'D:\2013', NO_SCREEN);
   END IF;
END;

Report message to a moderator

Re: How to check whether the folder exist in computer using oracle form 6i [message #603242 is a reply to message #603136]

Thu, 12 December 2013 09:12

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

Senior Member

I don't know how you managed to read this sentence:
Littlefoot wrote on Wed, 11 December 2013 16:32

Or, write a DOS batch script according to this discussion which would use DOS "IF EXIST" command; you'd call that script with Forms' HOST built-in.

and come to the conclusion that IF EXISTS is a forms command.

As LF says IF EXIST is a DOS command. So it needs to go in dos script, which you then call using host.
Forms has zero idea what IF EXIST is.

Report message to a moderator