Forms :: Form Where User Can Search Database On Basis Of Language And Name?

Jul 2, 2013

There is a table called cd_details. It has fields like id, name, language, type etc.I need a form where the user can search the database on basis of language and name and then display the other details. I used a data block wizard and given a push_buttonwith (execute_query). But it's very clumsy. For eg, if the user presses next the next button then all the records are being displayed. Is there any way to do this thing in a better way?

View 13 Replies


ADVERTISEMENT

Forms :: Search Data On Basis Of Date Range?

Sep 13, 2010

i create form on which 3 window, 3 Canvas, 3 blocks are there.

1)first block contain 3 items from_date and to_date(nondatabase)and find button

2)second block contains 3 items segment1, quantity and payment_terms

when i enter 2 dates and click on find button 2nd window open. segment1 and quantity between this 2 dates comes from base table like

select segment1,quantity
from po_lines_all pll, mtl_system_items mts
where pll.ITEM_ID=mts.INVENTORY_ITEM_ID
and creation_date between :FROM_DATE and :TO_DATE

and payment_terms should enter manually

3)2nd block contains summary button when i click on it, it save segment1, quantity, payment_terms and open new window which contain segment1 ,qty, payment_terms and when i click on summary button data comes from custom table which group clause means

suppose

item qty terms
a 2 2days
a 3 2days
b 3 3days

then on third form i shows like this
a 5 2days
b 3 3days

i done all this things but problem is that

suppose once data between 21-aug-2010 and 24-aug-2010 comes on second form , i enter payment_terms and save it. sumaary form also run properly but if another user enter date between 22-aug-2010 and 30-aug-2010 then it will shows data between 21-aug-2010 to 24-aug-2010 from custom table i.e with payment terms as earlier it save and from 25-aug-2010 to 30-aug-2010 it shows data from base table

like

item qty terms date
a 2 2days 21aug
a 3 2days 22aug
b 3 3days 24aug
b 4 NULL(ENTER MANUALLY) 26aug
c 5 NULL 27aug

View 1 Replies View Related

Forms :: Connecting To Other Database User Inside A Form

Mar 8, 2012

I have a problem concerning change of the connection inside a form. I have this code in when validate item trigger

LOGOUT ;
LOGON ('FIFES_HN','FIFES_HN@PRD_253');
MESSAGE (GET_APPLICATION_PROPERTY(USERNAME));
MESSAGE (GET_APPLICATION_PROPERTY(USERNAME));
MESSAGE (:DAILY_TRX_CONT.ORG_ID);
[code].........

how the last message is 'FIFES_HN' it show be 'SIFESD'

View 7 Replies View Related

Forms :: How To Create User - Defined Search In Runtime Oracle 6i

Sep 24, 2012

Is it Possible to create User - defined Search forms in runtime oracle forms 6i . If One Having sample Forms

View 1 Replies View Related

Forms :: 6i - How To Know Which User Is Using Which Form

Sep 8, 2011

How to know which user is using which form.I am using form 6i and Oracle 10g a database.

View 3 Replies View Related

Forms :: Login In Same Form With Different User?

Dec 1, 2010

I have a mainform through which one can access 3 different application(say a ,b,c)i have made three push buttons by clicking it the main menu of the respeective application is called.The three applcication have different users(user a,user b,userc)and have different database on the same version(db1,db2,db3 on 111g).I am using formservlet and i am calling the main form. configuration.I dont want the user to enter the username and password so i have hardcored it in formsweg.cfg file. my problem is that i login to the main form as 'user a' so i can access the application'a'.but now if i want to access applicatin 'b' how can i can i login as 'user b'?

View 6 Replies View Related

Forms :: Tableau Contains Data On Database - Do Button Search?

Jan 6, 2013

I have a tabeau that contains the data on my database, and I above table a "search" button that allows you to search for my DB, the problem must be the Result shown table or it already contains records what should I do?

View 13 Replies View Related

Forms :: User Defined Login Form

May 3, 2011

I have designed a Login form which takes username, password and connect string is hardcoded.I have compiled it, made an fmx file. created a shortcut to desktop. given the BIN path in shortcut.

when i want to lauch it, oracle's default login popup is shown.It can be by passed while defining username/password@string in shortcut properties but it reveals the password. every one can access it. I want to launch my own form without logging in to oracle. how can i avoid default login popup?

View 8 Replies View Related

Forms :: Display Sysdate And User On Item Form

Aug 7, 2010

query also a button click the trigger used when button press event user then the write this query.

SELECT USER INTO :BLOCK3.DISPLAY_ITEM7 FROM DUAL;

View 7 Replies View Related

Forms :: Connection String In Form Builder 6i To SYS User

Jun 9, 2013

i want to create a form like a console with form builder 6i for databases monitoring. I have to connect to more than 10 databases and monitoring them at same time.

My question is, how can i create connection string for each one in form builder? after connect to per database i want to select some quires, for example

:
"select STATUS from v$instance;"

Attention: i don't want use db-link

View 2 Replies View Related

Replication :: Update Database On Daily Basis?

Feb 7, 2013

There are 2 databases, database A and database B. Database A is Oracle 11.2.0.2 which runs on linux and Database B is Oracle 11.2.0.2 which runs on windows xp machine. In database A, there are 100's of tables which are being updated every 10 minutes or 15 minutes. For reporting purpose, the developer wants to run report for the tables. But since database A is being updated every now and then, generating reports takes almost 15 to 20 minutes. So the reports can be generated in Database B. Once in a day the database B should have the updated data from database A so that the reports can be generated in database B with less time. What could be the best solution for the database B to have the updated data on daily basis from database A in oracle?

View 3 Replies View Related

Database Script Take Backup On Daily Basis

Sep 30, 2012

DB 10.2.0.2
OS Window Server

I need to create a script to take the oracle database backup on daily basis for windows. Which method will be good exp imp, rman or coldbackup?

In our case mostly chance system will crash and we need to OS install first and then restore the oracle home and full database.

View 8 Replies View Related

Forms :: Customizing A Standard Form To Allow User To Copy Values

Dec 18, 2012

I am customizing a standard form to allow user to copy values. It works fine when I open the form, query a record and hit copy. But if I copy something to the clipboard from the records before I hit copy button, the form behaves differently and throw errors. Can I do something before the copy procedure work to eliminate this error?

View 3 Replies View Related

Forms :: Tabular Form - Restrict User To Enter Only 10 Rows

Dec 18, 2012

i have master and detail form. In detail(tabular form) i want to restrict user to enter only 10 rows.if he tries to go for 11th row he shud get a message (Only 10 records can be created at a time).

View 3 Replies View Related

Forms :: Generate Unique Document Numbers When More Than One User Inserting In Form At One Time

Dec 5, 2011

I have made one application form where users need to enter some data. This data is getting inserted in four tables. As in for now the data is properly getting saved and retrieved only for one user at a time. But problem arrives when more than one users are simultaneously making an entry and saving the data at one time.Same number is getting generated for the users who are saving the data at one time which should not happen.

View 4 Replies View Related

Search History For All Tables Created By A User

Mar 28, 2012

I want to find the history of manipulation the database by filtering the user who created the last tables, what tables are, when he created it etc ..

I'm using oracle XE and the client is toad.

View 3 Replies View Related

Data Guard :: Take RMAN Full Backup Of Standby Database On Regular Basis?

Jun 8, 2012

I use windows 2003 server, oracle 10.2.0.4.0.My question is related to maintaing a standby database

1. Do we need to take RMAN full backup of standby database on a regular basis? At the moment I dont take backups of standby database.

2. I have FRA on standby database. The archivelogs from primary go to FRA on standby. I delete my archivelogs as follows:

DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3';

Though the archivelogs are delete there are still empty folders of archivelogs that are not deleted. How to get rid of them automatically.

View 2 Replies View Related

Forms :: Data Copy Into Other Location On Daily Basis

May 22, 2010

I need any good suggestion basically I have two different location

1- Factory
2- Head office

I have developed PRODUCTION module in factory and it is working fine and now I want to send data on daily basis to head office therefore I develop a form which will create backup in export format (.dmp) then user will send via email to head office.

Backup file should be save in pre-defined location then user will use a form which I developed for loading data into head office there are two different buttons in this form;

First is used to load data, actually first I load data in a temporary user which creates whenever user will press this button. Second is used to copy data in application user but first it checks if data exists then update otherwise insert.

View 1 Replies View Related

Search Between 2 Specific Dates Which User Will Enter In Format

Feb 12, 2007

i'm creating a website where i can search between 2 specific dates which user will enter in the format of DD-MM-YYYY. the 2 dates will be inserted into 2 fields which is $input1 and $input2.

extract($_POST);
//to set the date format
//***************************
$input1 = date('DD-MM-YYYY h:i:s');
$input2 = date('DD-MM-YYYY h:i:s');
[code]...

but i get the error message saying...Warning: odbc_exec() [function.odbc-exec]: SQL error: [Oracle][ODBC]Option value changed., SQL state 01S02 in SQLExecDirect in C:phpwwwaaas_bbb.php on line 86...Error in SQL statement

View 2 Replies View Related

SQL & PL/SQL :: Change Oracle Database Language?

Feb 4, 2011

how can i change my oracle database language

View 6 Replies View Related

Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW

Apr 17, 2012

I cann't commit form when new instance form with form status is "NEW".

And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"

And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.

View 9 Replies View Related

Globalization :: How To Store India Regional Language In Oracle Database

Mar 5, 2013

How can we store data in Indian regional languages in Oracle database. We are using Oracle 10g.

Also i need to know can we convert existing data in oracle to local language ?

View 2 Replies View Related

Forms :: RTF Changes Not Shown For Specific Language

Mar 20, 2013

cookiemonster wrote on Wed, 20 March 2013 22:01Or if the user does anything to wipe the modified data - clear block, enter query etc - forms will also raise the alert.

i've uploaded a new RTF for Spanish but wen i login with the Spanish creds and run the program. Its not showing the changes i've chosen the right language and territory code.

View 1 Replies View Related

Forms :: Setup Arabic Language

Aug 8, 2010

My arabic data appears like ???????

How could I setup Arabic for forms , database?

I have 10G oracle database, forms,reports.

View 13 Replies View Related

Forms :: Multi-Language Support In 6i

Mar 12, 2012

I want to enter data in Arabic and English through Oracle Forms6i.

View 8 Replies View Related

Forms :: Setting Of Urdu Language

Feb 14, 2008

Any one tell me how can i enable urdu in oracle 9i which charter set will be use

View 2 Replies View Related

Forms :: How To Create LOV Via Own Mother Language

Apr 28, 2011

I am using Developer 6i and oracle 8i. when we r create LOV , it's generate by English language. and it's contains 3 button . this r find, ok , cancel button. but now i want this 3 button language show by my mother language(Bangla language). it's possible

View 1 Replies View Related

Application Express :: How To Change Language Of Version (integrated With Oracle Database 11g XE)

Apr 4, 2013

I downloaded Oracle Database 11g Express Edition R2 to test Apex (I've never used). I want to know how to change the language of the version of Apex (integrated with Oracle Database 11g XE)? I would apex in French.

View 7 Replies View Related

Forms :: Change Language - English To Arabic

Apr 18, 2010

Which is changing language in form from English to Arabic and vise versa during run time when I validate from item to another one ..

View 5 Replies View Related

Forms :: Language Specific Characters (apostrophe)?

Jun 2, 2010

I have a problem concerning the display of language specific apostrophes (Czech, e.g. in "Další") in Oracle Forms (Labels/Prompts):

In my local Forms Developer /OC4J they are displayed correctly, but when I copy the module onto the IAS (Unix) the are not shown correctly.I already tried several fonts, but none is working for me.

View 2 Replies View Related







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