Home » Developer & Programmer » Forms » How to check whether the folder exist in computer using oracle form 6i (Windows XP, Oracle form 6i)
How to check whether the folder exist in computer using oracle form 6i [message #603115] Wed, 11 December 2013 08:41 Go to next message
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...
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
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 Go to previous messageGo to next message
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 . , ()
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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

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 Go to previous messageGo to next message
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;


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 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: How to check whether the folder exist in computer using oracle form 6i [message #603263 is a reply to message #603242] Thu, 12 December 2013 13:02 Go to previous messageGo to next message
dark_prince
Messages: 121
Registered: June 2013
Location: India
Senior Member
Hi cookiemaster can you give me example of it...
Re: How to check whether the folder exist in computer using oracle form 6i [message #603265 is a reply to message #603263] Thu, 12 December 2013 14:28 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You didn't read the link I posted, did you? Please, open your mouth so that I could feed you /forum/fa/3943/0/.
Previous Topic: can't see fields in canvas
Next Topic: STACK AND TAB CANVAS HORIZONTAL VERTICAL TOOLBAR RELATED QUERIES
Goto Forum:
  


Current Time: Thu Mar 28 09:25:46 CDT 2024