Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Browse for files through oracle forms placed in unix server Post 302396268 by malinideepa on Thursday 18th of February 2010 05:10:11 AM
Old 02-18-2010
Browse for files through oracle forms placed in unix server

I use a forms application where I develop the forms(Oracle 6i) in windows server and compile(Oracle 9i) the same in Unix server.
The whole forms application executables are placed in Unix.
My requirement is to upload data from excel sheet to oracle tables using Oracle forms. I have developed the form.
The scenario is when I click on the UPLOAD button in the form it should browse for the file to be uploaded.
With windows application its working but not with the unix application.

I want the same thing for the application in Unix server also. In the Unix application when I click on the UPLOAD button nothing is happening

The code written behind the UPLOAD button is
-----------------------------------------------------------------------
Code:
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, 'ESN List (*.txt)|*.txt|' ); 
   IF lv_filename IS NOT NULL THEN 
      :FILENAME := lv_filename; `
   END IF; 
    
    
END;

-----------------------------------------------------------------------
What changes I have to do for the same thing to happen in forms which is connected to unix server.
I want the equivalent code which does the same for the forms placed in the Unix server
Please help on this issue.

Last edited by pludi; 02-18-2010 at 06:12 AM.. Reason: code tags, please...
 

9 More Discussions You Might Find Interesting

1. Solaris

compiling Oracle Forms in UNIX-solaris

I am using the command: f60gen to complie a form and it says it does not work Pls help, as I am trying to compile a few .fmb files to fmx... Cheers (1 Reply)
Discussion started by: etravels
1 Replies

2. UNIX for Dummies Questions & Answers

2 oracle version in unix application server

Hi, Ive got to 2 Oracle Versions in the application server. Currently running on 8.0.5, and I've recently installed 8.1.7. I would like to ask if it is possible upon restarting the server, to set the default environment to be pointing to 8.1.7 instead of 8.0.5? thnks (1 Reply)
Discussion started by: lucy
1 Replies

3. IP Networking

Unix Server Oracle

unix server oracle working with dump nodes. I want to connect to window base system by which i want to transfer the oracle data to window base plateform. Is there any way to connect. (0 Replies)
Discussion started by: shikhar_0509
0 Replies

4. UNIX for Dummies Questions & Answers

Unix Forms

Hi Im new so be gentle Just starting out in programing and i want to try unix to see what all the fuss is about. But right now im like a kid in a sweet shop, spoilt for choice. Theres red hat, fedora, linux, ubuntu and thats just for starters I've been told ubuntu is a nice... (3 Replies)
Discussion started by: NightWatchman
3 Replies

5. UNIX for Dummies Questions & Answers

Connecting to Unix server through Oracle

Hi, I need some help regarding oracle with unix script Actually i have a shell script and i want that it gets triggered through a oracle Db.I dont have any idea how is it done, even whether it is possible....pls help.....!!!! (3 Replies)
Discussion started by: fidelis
3 Replies

6. Shell Programming and Scripting

script for to take files from FTP server to UNIX server and Unzipped that files

script for to take files from FTP server to UNIX server and Unzipped that files (1 Reply)
Discussion started by: sunilamarnadh
1 Replies

7. Shell Programming and Scripting

Find and delete files and folders which are n days older from one unix server to another unix server

Hi All, Let me know how can i find and delete files from one unix server to another unix server which are 'N' days older. Please note that I need to delete files on remote unix server.So, probably i will need to use sftp, but question is how can i identify files and folders which are 'N'... (2 Replies)
Discussion started by: sachinkl
2 Replies

8. Programming

How to find Oracle forms that use a column in Solaris ?

I am trying to find all the oracle forms that have text item invoice_id in Solaris ( SunOS 5.10) If I use grep -i -l 'invoice_id' * I get only those oracle forms that have 'invoice_id' in the PL/SQL code. I want to find all the oracle forms that use invoice_id column in their datablocks.... (1 Reply)
Discussion started by: megha2525
1 Replies

9. Solaris

Help Required to access files in Oracle T4-4 server

Hello, First i'm a newbie, so don't mind if i sound stupid. I am working on Oracle t4-4 server with SUN SOLARIS 5.10 installed. I can access server via serial port and net mgt port. But the problem is when i login to console it starts flooding with messages and i can't type anything. I know... (4 Replies)
Discussion started by: Bilal Maan
4 Replies
focus(n)						       Tk Built-In Commands							  focus(n)

__________________________________________________________________________________________________________________________________________________

NAME
focus - Manage the input focus SYNOPSIS
focus focus window focus option ?arg arg ...? _________________________________________________________________ DESCRIPTION
The focus command is used to manage the Tk input focus. At any given time, one window on each display is designated as the focus window; any key press or key release events for the display are sent to that window. It is normally up to the window manager to redirect the focus among the top-level windows of a display. For example, some window managers automatically set the input focus to a top-level window when- ever the mouse enters it; others redirect the input focus only when the user clicks on a window. Usually the window manager will set the focus only to top-level windows, leaving it up to the application to redirect the focus among the children of the top-level. Tk remembers one focus window for each top-level (the most recent descendant of that top-level to receive the focus); when the window man- ager gives the focus to a top-level, Tk automatically redirects it to the remembered window. Within a top-level Tk uses an explicit focus model by default. Moving the mouse within a top-level does not normally change the focus; the focus changes only when a widget decides explicitly to claim the focus (e.g., because of a button click), or when the user types a key such as Tab that moves the focus. The Tcl procedure tk_focusFollowsMouse may be invoked to create an implicit focus model: it reconfigures Tk so that the focus is set to a window whenever the mouse enters it. The Tcl procedures tk_focusNext and tk_focusPrev implement a focus order among the windows of a top- level; they are used in the default bindings for Tab and Shift-Tab, among other things. The focus command can take any of the following forms: focus Returns the path name of the focus window on the display containing the application's main window, or an empty string if no window in this application has the focus on that display. Note: it is better to specify the display explicitly using -displayof (see below) so that the code will work in applications using multiple displays. focus window If the application currently has the input focus on window's display, this command resets the input focus for window's display to window and returns an empty string. If the application does not currently have the input focus on window's display, window will be remembered as the focus for its top-level; the next time the focus arrives at the top-level, Tk will redirect it to window. If window is an empty string then the command does nothing. focus -displayof window Returns the name of the focus window on the display containing window. If the focus window for window's display is not in this application, the return value is an empty string. focus -force window Sets the focus of window's display to window, even if the application does not currently have the input focus for the display. This command should be used sparingly, if at all. In normal usage, an application should not claim the focus for itself; instead, it should wait for the window manager to give it the focus. If window is an empty string then the command does nothing. focus -lastfor window Returns the name of the most recent window to have the input focus among all the windows in the same top-level as window. If no window in that top-level has ever had the input focus, or if the most recent focus window has been deleted, then the name of the top-level is returned. The return value is the window that will receive the input focus the next time the window manager gives the focus to the top-level. QUIRKS
When an internal window receives the input focus, Tk does not actually set the X focus to that window; as far as X is concerned, the focus will stay on the top-level window containing the window with the focus. However, Tk generates FocusIn and FocusOut events just as if the X focus were on the internal window. This approach gets around a number of problems that would occur if the X focus were actually moved; the fact that the X focus is on the top-level is invisible unless you use C code to query the X server directly. EXAMPLE
To make a window that only participates in the focus traversal ring when a variable is set, add the following bindings to the widgets before and after it in that focus ring: button .before -text "Before" button .middle -text "Middle" button .after -text "After" checkbutton .flag -variable traverseToMiddle -takefocus 0 pack .flag -side left pack .before .middle .after bind .before <Tab> { if {!$traverseToMiddle} { focus .after break } } bind .after <Shift-Tab> { if {!$traverseToMiddle} { focus .before break } } focus .before KEYWORDS
events, focus, keyboard, top-level, window manager Tk 4.0 focus(n)
All times are GMT -4. The time now is 02:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy