Forms :: How To Compare Two FMB Files

Jun 19, 2008

I have oracle base version and our client version. In oracle base version we have "products.fmb" file In our client version "item.fmb" file.it was created using the base version.After that many people made changes to client version. Now I want to compare those two files. But in our system there is no form builder. Is it possible to compare without FORM builder.

View 15 Replies


ADVERTISEMENT

Compare Two Dump Files And Their Respective Log Files

Jun 20, 2012

I want to compare two dump files and their respective log files, to see the difference. Is there any way.

View 8 Replies View Related

Forms :: Compare Two Tables With Rowid

Nov 1, 2013

is it possible to compare two tables with rowid? I want to put rowid in where condition...how can we do this?

View 4 Replies View Related

SQL & PL/SQL :: Forms 6i - Compare Start And End Dates

Feb 6, 2011

I am comparing the dates in forms 6i.I need to compare the start and end dates and if the date are getting than an year then i need to get an error message.

View 2 Replies View Related

Forms :: How To Compare Two Text Boxes With IN Operator

Jun 12, 2012

How we can compare IN operator between two text boxes in form

I have two text boxes on form
control.txt1 - 003

control.txt2 - 001,002,003

On button pressed

if :control.txt1 in (:CONTROL.TXT2) THEN
MESSAGE('1');
MESSAGE('1');

else

MESSAGE('0');
MESSAGE('0');
END IF;

All the time Message is 0 .

View 4 Replies View Related

Forms :: Compare Value Which Is Taken In Custom Block By User

May 26, 2010

i have created one custom block in that i am taking one value in text_item and on 2nd form i have data block on that block i want filter by using WHERE clause

in that where clause i want to compare value which is taken in custom block by user..what need to write in where clause?

View 1 Replies View Related

Precompilers, OCI & OCCI :: Make Files That Compile PC Files In Unix

Jul 31, 2008

I have written make files that compile .pc files in unix. This was for several projects that use an oralib source code directory.Just running proc on one target .pc file works fine on unix. I am trying to use proc - Oracle 10.2.0 - in windows and I keep getting:

Quote:unable to open include file
#include <stdio.h>
and other C library headers.

I am doing all development under cygwin, this way I can write a makefile just like under unix instead of using nmake.All C library headers are in /usr/include When I run proc on Solaris as that:

proc program.pc
No problems, and I do get program.c.

However in windows I get the previous error message. I have tried to do proc include=/user/include program.pc and proc include=/user/include parse=full program.pc but I still get the same error message.

View 3 Replies View Related

Forms :: How To Open PDF Files Using 6i

Feb 17, 2006

How 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

View 19 Replies View Related

Forms :: Open PDF Files

Jan 4, 2011

I have a PDF files in my file Server, i want to open it through Forms 10g .

View 9 Replies View Related

Forms :: How To Export SQL To MS Excel Using CSV Files

Jul 17, 2013

I create this because I need a way to export SQL commands in several forms to Excel without using CSV files. So this routine opens MS-Excel automaticaly and then export the data of the SQL into a sheet within the excel. Is a procedure that can be use in any form and using simple or complex SQLs.

I compressed 3 files in the TXT file. So, first change the extension from TXT to RAR and then unzipped the file.

View 6 Replies View Related

Forms :: Read Set Of Files From A Directory

Apr 28, 2011

Am creating a form for some processing text files available in a local users system. Now I would like to get the directory name from the user using dialog box and read the files

[ I am already reading the file, but I allow the user to select the specific file name using get_file_name ]

View 1 Replies View Related

Forms :: Export Files From OLE Container

Jun 15, 2010

how do I export files ole container forms forms 6i to 10g? OLE container I keep in the database in a BLOB field.

I want to watch it in Forms 10g using WEBUTIL or export to disk.

View 2 Replies View Related

Forms :: Compile Multiple Fmb Files At Once In 6i?

Feb 21, 2012

I need to compile multiple fmb files at once in FORMS6i.

View 1 Replies View Related

Forms :: Fmx Files Into Separate Folder

Apr 29, 2013

I have some .fmb files in 'F: ask" " ' location.and my question is can i store the .Fmx files in other location like 'D:" " '

that is if i create a .fmx file for the 'F: ask**.fmb'. i want That .fmx file will store into other location i.e 'D '

View 3 Replies View Related

Forms :: Copy Files From One Location To Another In 6i

Sep 9, 2008

I want to copy files from one location to another in forms6i on when button pressed.i m using the following code.

DECLARE
cpf_source VARCHAR2(500) := 'c: est.txt';
cpf_target VARCHAR2(500) := 'c:data';
begin
WIN_API_UTILITY.copy_file(cpf_source,cpf_target,TRUE);
end;

But i press the button it generates FRM-40734,

internal Error : PL/SQL error occurred.

View 5 Replies View Related

Know If Database Files Are On File System Or Raw Files?

Oct 11, 2012

How can I know if database files are on file system or raw files?

View 4 Replies View Related

Forms :: Cannot Display NEW GIF Files As Icon On Buttons

Feb 23, 2011

I already have and use .gif files for icons on various buttons in my forms. I need to use a different .gif file to create a new icon. When I enter the file name of the new .gif is not displayed on the button. If I reference an old and working .gif. The .gif appears on the button. What rules if any, must I observe when creating/using .gif files as icons for buttons?

Does the .gif file have to be of a special type? If so, what will I need to do?

View 1 Replies View Related

Forms :: Sending Email With Attached Files?

Jun 15, 2010

I am using the following code on a button and once I pressed the button the form disconnected.

Declare
Outlook_Object client_OLE2.OBJ_TYPE;
Mail_Object client_OLE2.OBJ_TYPE;
Item1 client_OLE2.OBJ_TYPE;
Item2 client_OLE2.OBJ_TYPE;
OLEPARAM client_OLE2.list_type;

[code]....

View 2 Replies View Related

Forms :: Test Custom Jar Files With 6i From Desktop?

Dec 18, 2010

I want to test custom Jar files with Forms 6i from my desktop, but I cannot get the Run Form->Web to work. Is it possible for the run time to load the just jars for PJC when you do Run Form -> Client/Server? So far, when I have done this, it does not execute any PJC.

View 2 Replies View Related

Forms :: Saving Excel Files As Object In Oracle?

Feb 13, 2012

How can we save Excel file as an objectin oracle. Like we can store image file.

View 1 Replies View Related

Forms :: Calling Java Class Files From PLSQL?

Jun 19, 2007

I have imported a java class file that inturn gets content from a webservice. One of the functions on that imported class file is as follows ...

Funtion getcontent(A1 JOBJECT,A2 JOBJECT, A3 String) return JOBJECT ....

In my PLSQL package ...How do I invoke this class file ?

So far I have done this ...

Declare
abc ORA_JAVA.JOBJECT;
xyz ORA_JAVA.JOBJECT;
xxx VARCHAR2(25);
value ORA_JAVA.JOBJECT;
BEGIN

[code]...

I am getting an error saying the object type is wrong .... I would like to know how to assign a hardcoded value to the JOBJECT just to test before I continue.

View 20 Replies View Related

Forms :: Make Push_button To Act As Browse Pictures Files?

Feb 19, 2010

How i can make a push_button to act as browse the Pictures files only to upload in Image Box. At Commit store in my Database.

View 1 Replies View Related

Forms :: Upload Files From Client To Application Server Using 10g

Oct 3, 2010

I have used webutil_file_transfer.Client_To_AS_with_progress to upload files from client to Application Server using Forms 10g.However, now i want to save file in database and not upload to database as blob.I mean I want to save the file from client TO a folder available in the database server.I was wondering, there is no documentation available on WEBUTIL.

View 6 Replies View Related

Forms :: Create A Form To Store Any Excel / Word Files?

Jul 1, 2011

i m using oracle 10g forms.

i want to create a form where i can store any excel / word etc files.

View 6 Replies View Related

Forms :: Tree Node Icons And Where Icon Files Are Located?

Mar 21, 2012

Tree node icons. I created a table named TEMP_USER_MENU and contains the following structure

USER_IDVARCHAR2(15)N
MENU_IDNUMBER(15)N
MENU_DESCVARCHAR2(150)N
FILE_NAMEVARCHAR2(100)N

[code]...

Now all i wanted is to change each node icon. This query just make the parent nodes icon to OPEN folder like icon and the leaf node to FILE. You can see the decode query up there. It just chose the icons from the File_Name field when it founds 0 then it shows it's a parent node it makes it icon to OPEN else it make it to NEW.

Fist thing i want to know that from where the form builder is fetching these icons? i.e. from which path and what format it looks like a .png file ? .ico or a .jpeg file. I have searched a lot online but all in vain.

Second thing if i want to add unique icons in my menu tree on each node. Is there any possibility ? if yes. Then where should i keep my icons files and in which format?

View 4 Replies View Related

How To Compare A Value In SQLLDR By Using WHEN

Feb 25, 2013

Can we compare in SQL *Loader control file by using WHEN Clause.I want to load the data when in_no greater than 1300000000. While running below control file i am getting error as:

SQL*Loader-350: Syntax error at line 5.
Illegal combination of non-alphanumeric characters
WHEN (in_no >= '1300000000')
Here is the control file.

ex:

Load Data
infile *
discardfile 'test_when.dsc'
truncate into table test_when
WHEN (in_no >= '1300000000')
fields terminated by ','
(a,b,c,
in_no)
[code]....

how to compare a value in sqlldr control file.

View 1 Replies View Related

SQL & PL/SQL :: Compare Two Different Table?

Jul 11, 2011

I want to compare two tables column by column and find out which columns are matching and inserting matching columns value into another table.

View 1 Replies View Related

SQL & PL/SQL :: How To Compare The Four Tables

Jan 5, 2013

I Have Four Tables

1) Sal_master
structure is voc_no varchar2(7),voc_date date

2) sal_detail
structure is voc_no varchar2(7),item_code varchar2(10),quantity number(10,2)

3). delivery_master
structure is voc_no varchar2(7),voc_date date;

4) delivery_detail
structure is voc_no varchar2(7),item_code varchar2(10),quantity number(10,2)

I want to compare these four tables i have insert 10 rows in sal_master and sal_detail tables and 5 transaction in delivery tables how to compares 10 records of sal_master,detail with delivery_master and detail if not exist in delivery_master and detail tables then display only sal_master,detail records for example

Voc_no Sale Qty Deliver Qty Remaining Qty

S000075 10 5 5 if data not found from delivery master and detail then answer must be
S000075 10 0 10

View 2 Replies View Related

SQL & PL/SQL :: To Compare Two Strings

Apr 8, 2008

I have requirement wherein i need to compare two strings (with multiple words) and it should return the %(percentage) of comparison.
e.g. "oracle infotech" and "infotech oracle" are 100% match

Do we have any oracle built ins to compare ?

View 6 Replies View Related

SQL & PL/SQL :: How To Compare Time

Jun 30, 2010

Checkout the following code

CREATE TABLE CHK(dt_request_datetime DATE);

INSERT INTO CHK VALUES(TO_DATE('25-JUN-10 04.12.57 AM',
'DD-MON-YY HH:MI:SS AM'));

COMMIT;

[Code].....

TZ_OFFS TZ_OFFS GMT_TIME
------- -------
-04:00 +00:00 25-JUN-10 04.12.57.000000000 AM

EST_TIME
-----------
25-JUN-10 12.12.57.000000000 AM EST

9 am
----
25-JUN-10 09.00.00.000000000 AM EST

8 pm
-----
25-JUN-10 08.00.00.000000000 PM EST

OUTPUT
---------
30-JUN-11

My doubt here is that even though dt_request_datetime is between 9 am in EST timezone and 8 pm in EST timezone the query output is not according to that.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved