Home » Developer & Programmer » Forms » GET_FILE_NAME functionality (Oracle Forms 6i)
GET_FILE_NAME functionality [message #446453] Mon, 08 March 2010 09:39 Go to next message
crushguy2003
Messages: 3
Registered: April 2007
Location: India-TN-Chennai
Junior Member
Hi all,
can anyone help to solve the issue....

I have my forms application working on both windows and Unix platform. When i am using GET_FILE_NAME ( ), it is working fine in Windows based application but the same is not working in Unix based application... What might be the issue?

Thanks
Arun
Re: GET_FILE_NAME functionality [message #446454 is a reply to message #446453] Mon, 08 March 2010 09:46 Go to previous messageGo to next message
cookiemonster
Messages: 10903
Registered: September 2008
Location: Rainy Manchester
Senior Member
Posting the full code and telling us in what way it's not working would help.
Re: GET_FILE_NAME functionality [message #446529 is a reply to message #446454] Tue, 09 March 2010 02:50 Go to previous messageGo to next message
crushguy2003
Messages: 3
Registered: April 2007
Location: India-TN-Chennai
Junior Member
Hi, Pls chk it..
The following code works fine in windows based application but not in Unix based application.

DECLARE
lv_dirname VARCHAR2(255);
lv_filename VARCHAR2(255);
BEGIN
tool_env.getvar('DEMO20', lv_dirname);
lv_dirname := 'c:\';
lv_filename := get_file_name(lv_dirname, NULL, 'List (*.csv)|*.csv|' );
IF lv_filename IS NOT NULL THEN
:FILENAME := lv_filename;
END IF;
--go_field('LIST_NM');
END

When running, opens c: of server in windows based but nothing in Unix based..

Do we have any different builtin function to get the same functionality in Unix based application?

Thanks
Arun
Re: GET_FILE_NAME functionality [message #446532 is a reply to message #446529] Tue, 09 March 2010 03:07 Go to previous messageGo to next message
Littlefoot
Messages: 19474
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't use UNIX, but I doubt that its directories are named as "c:\".
Re: GET_FILE_NAME functionality [message #446533 is a reply to message #446453] Tue, 09 March 2010 03:08 Go to previous messageGo to next message
cookiemonster
Messages: 10903
Registered: September 2008
Location: Rainy Manchester
Senior Member
Well considering there isn't a 'c:\' directory in unix that was never going to work on unix machine.
Re: GET_FILE_NAME functionality [message #446738 is a reply to message #446533] Wed, 10 March 2010 03:57 Go to previous messageGo to next message
crushguy2003
Messages: 3
Registered: April 2007
Location: India-TN-Chennai
Junior Member
Hi
Even i tried with the Unix path also as following:
DECLARE
lv_dirname VARCHAR2(255);
lv_filename VARCHAR2(255);
BEGIN
tool_env.getvar('DEMO20', lv_dirname);
lv_dirname := '/iasapp01/relwhapp/forms';
lv_filename := get_file_name(lv_dirname, NULL, 'arun_data (*.csv)|*.csv|' );
IF lv_filename IS NOT NULL THEN
:FILENAME := lv_filename;
END IF;
--go_field('LIST_NM');
END;

Nothing is happening when i run it...

Pls let me know the soln..
Re: GET_FILE_NAME functionality [message #447549 is a reply to message #446738] Tue, 16 March 2010 00:22 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please use 'code' tags on your code.

Please place 'message;pause;' pairs in your code and tell us on which line the code is stopping.

Also look at other posters' 'getvar' usages, for example, http://www.orafaq.com/forum/m/395734/67467/?srch=getvar#msg_395734

David
Re: GET_FILE_NAME functionality [message #480502 is a reply to message #447549] Mon, 25 October 2010 05:53 Go to previous messageGo to next message
mego
Messages: 2
Registered: October 2010
Location: CAIRO
Junior Member
Hi ,
Can any one just guide me to know why get_file_name function which worked in forms 6i is not working in forms 10g.

Thanks
Re: GET_FILE_NAME functionality [message #480510 is a reply to message #480502] Mon, 25 October 2010 06:58 Go to previous messageGo to next message
Littlefoot
Messages: 19474
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I just checked Forms 10g Online Help, and - in a TEXT_IO package example - there's a GET_FILE_NAME function. So, I'd say that it *should* be still working. What makes you think the opposite?
Re: GET_FILE_NAME functionality [message #480805 is a reply to message #480510] Wed, 27 October 2010 06:11 Go to previous messageGo to next message
mego
Messages: 2
Registered: October 2010
Location: CAIRO
Junior Member
I appreciate your effort, but the problem is I have a 6i application which includes a form works properly and I can browse and select an image file using
the GET_FILE_NAME directly (with no need to use any TEXT_IO functions because I just browse and select an image file), when I compiled this form to 10g with no compilation errors and run it the function returns null value for the filename.

- I checked the on-line help before trying to ask but the GET_FILE_NAME only appear in the TEXT_IO example.
- I checked the FORM_PATH in the regedit to ensure that the images folder is reached.
- I wrote the images path explicitly in the GET_FILE_NAME but no way.
- finally I searched the Internet to reach here.
- The code is very simple only to browse and select a file:

DECLARE
FNAME VARCHAR2(200);
BEGIN
FNAME := GET_FILE_NAME('PIC Files (*.GIF)|*.GIF|');
IF FNAME IS NOT NULL THEN
READ_IMAGE_FILE(FNAME,'GIF','COMPANY.LOGO');
:LOGO_PATH := FNAME;
IF NOT FORM_SUCCESS THEN
MESSAGE('NO IMAGE FOUND');
END IF;
IMAGE_ZOOM('COMPANY.LOGO',ADJUST_TO_FIT);
ELSE
SMS('NO FILES WERE BROWSED');
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN
SMS('NO IMAGE WAS SELECTED');
WHEN OTHERS THEN
SMS('PLEASE CONTACT YOUR ADMINISTRATOR');

END;
Re: GET_FILE_NAME functionality [message #597882 is a reply to message #446453] Wed, 09 October 2013 01:52 Go to previous messageGo to next message
mo7asb
Messages: 4
Registered: November 2009
Junior Member
hi
i want to know if any solution for this
or other function i can use to open dialog via Ebs 11.5.10 in unix server
Re: GET_FILE_NAME functionality [message #598022 is a reply to message #597882] Wed, 09 October 2013 14:59 Go to previous message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
Dear i dont have UNIX Enviroment but this code may be help you

DECLARE
  FNAME VARCHAR2(200);
BEGIN
  FNAME:=GET_FILE_NAME(' ',NULL,NULL,'select your directory.',OPEN_FILE,FALSE);
  :ti_path:=FNAME;  
END;


Regard
Mughal
Previous Topic: excel sheet on local machine
Next Topic: forms 10g, win xp 32 bit
Goto Forum:
  


Current Time: Thu Aug 21 06:11:01 CDT 2014

Total time taken to generate the page: 0.06884 seconds