i have oracle from 10g installed. i have added webutil libraries.and its has been complied succesfully.now i have a one button on form. on that button triggerd i want open dialog box to select the file.like browse.
for that i have used below command.
webutil.Client_Get_File_Name('C:','file_name.xls','XLS Files (*.xls)|*.xls|',NULL,OPEN_FILE,TRUE);
but it showing me error i.e 'Client_Get_File_Name muse be declare'..
i want to open dialog window using oracle forms 10g on button click event.
View 3 Replies View RelatedWhen using this awesome plugin, I have a dynamic action on my calling page that deals with the selection from the dialog.
It uses
Select type:DOM Object
DOM Object: document
Condition: javascript expression
($v('P110_PROD_SEARCH') == 'BLAH')
where the js expression is making sure I run the correct dynamic action, particularly when I have a few buttons on the page invoking different variations of the modal dialog.
My first action is some javascript that interrogates the value of this.data.modalPageCloseValue this facilitates me make decisions in later actions on whether to run some pl/sql, for instance.
potential APEX bug (Display item with HTML affected by dynamic action and since we can't put conditions on actions - I was wondering if I could incorporate something into my dynamic action condition to stop the entire dynamic action from executing if modalPageCloseValue is null - but it seems to be out of scope?
I notified some strange behaviour of my forms debugger. When I insert debug.attach piece of code into ma form and fired them on Windows machine after inserting into Oracle forms builder debugger dialog box server name (usualy ip) and given port from oracle forms window then everything works fine, breakpoint is catched. But when I changed my OS to RedHat then I am not able to come into all kind of trigger form code. Only program units could be debugged.
View 7 Replies View RelatedI am trying to use client_get_file_name to display the select file dialog box. My problem is that I can get the dialog box to open but it does not default to the folder that I specify in the client_get_file_name parameter (r_system_data.import_dir points to c:
eports).
v_filename := client_get_file_name(r_system_data.import_dir, null,
'CSV Files (*.csv)|*.csv|',
'Select a file to import travel details from');
The strange thing is when I use JInitiator 1.3.1.22 the diolog box defaults to the c: eports folder but when I use J2SE JRE 1.5.0_21-b01 it defaults to c: emp (which is where 'My Documents' points to, may be just a coincidence)
I am running Windows XP SP3 with IE8.
how to know when a user was navigating away from the current open form (and I wanted to prevent the navigation with a dialog box) because they had entered a new URL in the address bar and were trying to navigate to it? I've seen a reference to it from an ADF perspective -> [URL]
but was wondering how to do it within Forms?
The reason for this is that i would want to prompt the user to confirm that they wanted to exit the form as potentially they would have a record (in the form) flagged as being updated and as such no other user (including themselves) could susbequently access it. So, I'm basically wanting to know if there is a way to catch the fact that the user is about to navigate to another web page.
Is it by using javascript and if so, how would it be implemented?
i want to create a simple form in this form i want to upload the image on the image item with browse button that open a diaglog box that go to the image i select the image and this image is display on image item on the form.
View 1 Replies View RelatedI have u na forms developer application in 6.0 that generates a Word document. This application runs successfully on Windows XP operating system. We now have PC's new operating system Windows 7 and officce 2010. My procedure reads a specific route where a template in Word which is used to generate the document. In the user's PC application that does not generate the document even shows me an error message. But when I enter my network user with the user's PC and the document genre generates me perfectly. I checked if the user has access to the server path specifies where the template encuntra wish to open and if you have them.
View 1 Replies View RelatedI have designed a report (by oracle report 6) when i run it on the report preview when choosing print the print dialog box doesn't appear on other pc the dialog box appears.
I want the print dialog box to show.
I set the JOBPRINT parameter to yes which is the default value but didn't solve it.
OS: WinXP
Developer Suite 10g Rel.2
its a very basic query, i want to open multiple .fmb / .rdf files at once ( like pressing Shift or Ctrl key when selecting multiple files ), but its not allowing me
Is there a shortcut to get the Select Connection Dialog box in SQL Developer?
Every time I need to execute a Query I have to use the mouse to change the Connection, if there is any Shortcut then that would be easier for me to wotk with.
I install Forms 11 g . how i an use my Old Fmb files ? (my forms designed in forms6 i )
View 2 Replies View RelatedHow can I open any pdf(Acrobat Reader) file thru Oracle Forms 6i through procedure. I have written procedure to open .Doc & .XLS files by using OLE2.Create_Object but unable to do for .PDF files.
I m attaching the code in txt file , how i have done it for word
open_word is the name of the procedure/program unit
How to open a URL from oracle forms ?
Select APP_SERVER_URL into p_url
from CA_EXT_INT_PARAM
where FACILITY_ID =facility_id;
SELECT appl_user_password INTO p_user_password
FROM sm_appl_user
WHERE appl_user_id = P_Login_User;
[code]...
Above coding throws a error unable to open a link..
I have a PDF files in my file Server, i want to open it through Forms 10g .
View 9 Replies View RelatedI am trying to read/write Open Office scalc.exe(which is replacement of Excel file) file using DDE Package as like Excel File. But it is giving me non oracle Exception Error when it focused or initiate.
View 2 Replies View RelatedI have a folder "c:Images" which has around 5 image files they all are Tiff Images. now from forms i want to open this images one by one.
example:
file 1: SIGN.TIFF
file 2: FORM.TIFF
file 3: FORM_1.TIFF
File 4: FORM_2.TIFF
File 5: PHOTO.TIFF
I have the form and in that I have only one Image Item and two buttons with name "Previous" & "Next"
Action to be Done:
-> Initially when i start form SIGN.TIFF has to open.
-> when i press next FORM.TIFF has to be replaced with SIGN.TIFF
so on...
Note: There is a chance of keeping 10 more files.
How can this be achieved in forms.
How can i open a new Excel application from Forms 10g?
View 2 Replies View Relatedi am trying to open a .pdf file in oracle forms 10g which had stored in oracle 9i.10g database.
so which method shall i use to do this?
how can i open the .fmx file in oracle 10g?
View 12 Replies View Relatedi have fmx file and i want to open it in any text editor
View 7 Replies View RelatedI working in windows environment and using form 6i. Everyone have used the same form and they are getting properly. But when i run the same form i am getting the following error.
PDE-DFF003: Can't Open Library : D2KWUT32.DLL
I am getting the above error when i execute the following line on when - button - pressed
w_user := Win_Api_Environment.Get_Windows_username(False)
When I am trying to open a PLL[5i] through Form5i Builder , Getting Error message like "FRM-10043 Cannot open a File".
View 1 Replies View Relatedi have one word doc file name is sample.doc
i have 3 buttons in my canvas. 1st button is to open a word document.
codings:
declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin('D:Program FilesMicrosoft OfficeOffice12winword.exe F:DevSuiteHome_1formssamples.doc',DDE.APP_MODE_NORMAL);
end;
2nd button:
i want to delete the existing sample.doc file via forms
i dont know the codings.
I need to open an excel sheet from PL/SQL program where I will put in the data. How to open an excel sheet from Pl/sql code.I got hold of a code as below Looks like I need to configure DAD PL/SQL
BEGIN
-- Prepare Headers
owa_util.mime_header('application/vnd.ms-excel',FALSE);
--htp.p('Content-Length: '||document_length||NL_CHAR);
--htp.p('Content-Length: '||document_length);
[Code]....
I have One .FMB Screen and in this Screen One Table , I Compile and attach in ERP System but when I tried to open thst screen is not open and also application is stucking.
View 1 Replies View Relatedis it possible to create a button can open directory like My Documents
i test this in CMD command prompte it's work but in forms they are not work
"explorer.exe" & @MyDocumentsDir
or
cmd /c "explorer.exe" & @MyDocumentsDir
in forms : i create a button with trigger When-button-pressed
my host('"explorer.exe" & @MyDocumentsDir');
host ('cmd /c "explorer.exe" & @MyDocumentsDir');
but it's not work
I want to use dialog for selecting file in Fomrs 6i.I attached d2kwutill.pll into form, i uploaded d2kwut60.dll into <ORA_HOME>/bin and coded WIN_API_DIALOG.OPEN_FILE to open file. Everything works fine on the machine I'm developing, the open file dialog works and it returns file name. But when i upload form on remote machine where i access through the web it won't work.
I uploaded d2kwutil.plx on remote machine to the directory where forms reside. This is when I attach library without storing full path of it which is in my case c:someFormsDir - note! on remote machine Forms reside on d:Forms, and on local machine I have only c: HDD D: is cdrom and i can't change drive letters.
I also try to upload d2kwutil.plx in c:someFomrsDir on remote machine although forms there reside in d:Forms, but on local machine library(and forms) reside in c:someFormsDir.
None of two above examples work.
I upload d2kwut60.dll in <ORACLE_HOME>in direcotry - doesn't work. I even upload d2kwut60.dll in orahome2in direcory, doesn't work. On my local machine d2kwut60.dll is in ORA_HOMEin where ifsrv60.exe can be found, the same i do on remote.
When I puch button to open dialog for choosing file Internet Explorer freezes.
i was create simple two forms in the first forms i want to create a hyperlink that open another forms.
View 1 Replies View RelatedI've a button on a form and I wrote a trigger when button pressed to open a pdf file and it worked fine this was my
declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin('C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe Z:BUILTINS.pdf',DDE.APP_MODE_NORMAL);
end;
The thing is this form is used by multiple clients and if a user has a different version of acrobat reader rather than version 8 this will not work how to do it to be uniform?