Forms :: Create A Form For Ordering

May 25, 2010

i create a form for ordering>>>that the person can enter his/her information and isbn book to make the order,but the order id i make it sequentially! well first of all i create a data-block and i insert only the oid in trigger when-new-item-instance..i had create the sequence:

declare
create sequence seq1
start with 90
increment by 10;
end;

and i make a view form such of fields that user can enter a details o what he/she want to order!!

1- is that enough?

2- it seems there is an error in creating the sequence?? wrong way to create the sequence!!

View 7 Replies


ADVERTISEMENT

Forms :: Create Login Form In 10g?

Jun 17, 2011

how to create a login form in forms 10g how upload login.fmb

View 2 Replies View Related

Forms :: How To Create Login Form

Oct 23, 2013

I have made few forms , but i want only those users to access these forms who have valid login and password to access these forms.

For example i have created one form employee details (shows the details of emp table in tabular form) which is based on emp table.
The users are scott having password tiger ,and User Test having password Test. i want to make a login form to give access to only these users to access employee tables. if someone else tries to access it then it should show Unauthorized login error.

My requirement is i want to create a basic login form which includes

Login i.e Text_item
Password i.e text_item
Login i.e push button

what should be the queries behind these items. and how to connect this form to database. I am attaching file , just add working codes in that or you can write codes here also .

View 25 Replies View Related

Forms :: How To Create Multilingual Form

Feb 4, 2011

My requirement is to create Multilingual form. Its very urgent. In fact if i want to make it work in 2 languages. English and Chinese.

View 1 Replies View Related

Forms :: How To Create Sequence In Form

Jan 13, 2013

I know how to create sequence in the database.But I want to create this sequence from the form by giving the name of the sequence from a filed in the form.

View 1 Replies View Related

Forms :: Create Directory With Oracle Form PL/SQL

Jan 16, 2010

i want to know how to create directory or folder which use pl/sql coding in oracle developer suite10g

my problem is when i use this code

trigger WHEN-BUTTON-PRESSED

EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY'||'C:RESTAURANT';

IT'S ERROR WITH "Error591 this feature is not supported in client-side programs"

I used to use function with webutil that's webutil_file.create_directory('c:RESTAURANT');

trigger WHEN-BUTTON-PRESSED

WEBUTIL_FILE.CREATE_DIRECTORY('c:RESTAURANT');

BUT STILL HAVE ERROR WITH "Error 221 'CREATE_DIRECTORY' is not a procedure or is undefined "

How to create directory with pl/sql that's use in oracle form in trigger when-button-pressed or how to use function webutil_file.create_directory();

View 9 Replies View Related

Forms :: How To Create MASTER_DETAIL Form Manually

Oct 25, 2013

I know how to design master_detail form using wizard but i want to create it without using wizard.I have created two blocks emp and dept without using wizard ,and connected them to emp and dept table by changing their properties.Now i want to create relationship between these two blocks, My requirement is when i press execute_query button if deptno is 10 in dept block then emp block should show data for deptno 10 only.

I know it can be done using add relationhip option in dept block (which is master block)but how to do that.

View 8 Replies View Related

Forms :: Create Login Form With Validation

Dec 4, 2010

I just need to create a login form ..its like user will login using his given id and password will be encryted when entering and i just need to simple validation that if he has entered corrected password it will display message ok or else wrong password.

View 3 Replies View Related

Forms :: Create Hyperlink That Open Another Form

Sep 18, 2010

i was create simple two forms in the first forms i want to create a hyperlink that open another forms.

View 1 Replies View Related

Forms :: How To Create Form Dynamically At Runtime

Dec 26, 2011

I am working with forms 6i..Is it possible to create form dynamically at run time..

View 2 Replies View Related

Forms :: How To Create Browse Button In Oracle Form Builder

Mar 19, 2010

I would like to create a browser button which enables to browse a tree directory and to select a file. how can i do it?

View 1 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 :: 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

Forms :: Opening Form Has Attached Libraries Caused Form Close

Jul 19, 2010

If I open a form has attached libraries in form builder on windows7 it closed and give this message :

Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll

[code]......

View 14 Replies View Related

Ordering By Date

Jan 13, 2012

Been cruising all sorts of ways to order by. My last ditch effort my be to use the WITH clause, but I don't want to go there just yet...

Using Oracle 10G against a database that uses a COTS CHAR datatype schema against an in-house varchar2 datatype schema (hence all the trims you will see in there so I can get proper joins)

Here is my query in question. Beware it's somewhat eye-bleeding!

select * from (
SELECT
int.part "Part",
int.lot_nbr "Lot",
int.stkrm "Stkrm",
int.location "Location",

[Code]...

Now obviously no one would be able to run this... But here is an example of how this is spitting out the ordered by date:

31-Mar-2011 12:00:00 AM
31-Mar-2011 12:00:00 AM
31-Mar-2011 12:00:00 AM
28-Sep-2011 12:00:00 AM

[Code]...

It's like it's ordering it by the day only...

View 3 Replies View Related

Forms :: Want To Call Web Form For Uploading Image From Custom Form

Apr 16, 2013

I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.

View 1 Replies View Related

Forms :: How To Reload Calling Form After Closing Called Form

Jul 15, 2007

I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.

How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?

View 13 Replies View Related

Query Ordering By Relevance

May 26, 2009

I have an Oracle query that I have built based on user input... user enters a description (multiple words) and I search for existing descriptions like it. For instance I may have a record like "My name is matt". Right now the query looks like

select * from table where
(field1 like '%My%' or
field1 like '%name%' or
field1 like '%is%' or
field1 like '%matt%');

There may be tons of records that have at least ONE of these, but I want to order by relevance, so a description "my name is bob" (3 words in common) will appear before "his name is not mine" (just 2 words in common).I have seen the SCORE() and CONTAINS() functions but not sure about multiple search criteria.

View 8 Replies View Related

SQL & PL/SQL :: Asc / Desc Ordering Data

May 23, 2011

I am working on ORACLE 9I. I am ordering(ASC/DES) the data one column whose values are

SALES-1
SALES-14
SALES-15
SALES-2
SALES-3
SALES-11
SALES-12
SALES-13
SALES-4
SALES-5

When i do the ascending order dat looks like

SALES -1
SALES-11
SALES-12
SALES-13
SALES-14
SALES-15
SALES-2
SALES-3
SALES-4
SALES-5

but it should display as

SALES-1
SALES-2
SALES-3
SALES-4
SALES-5
SALES-11
SALES-12
SALES-13
SALES-14
SALES-15

View 2 Replies View Related

SQL & PL/SQL :: Analytic Functions And Ranking / Ordering?

Jul 17, 2008

I need to return an ordered list of documents. The documents may belong to a set id (optional) and if so, are either a "master" or a "duplicate" type. For each set there can be only one master but many duplicates. My goal is to group all the sets together such that each master is proceeded by its duplicates.

Table description:
document_master_duplicates
(
documentid,
duplicate_setid,
is_master
)

This needs to join to another table briefcase_documents which contains our set of documents. The briefcase / document relationship is many-to-many.

Table description:
briefcase_documents
(
briefcaseid,
documentid
)

There's also a documents table containing the documentid and among other things a page_count. In the following example I want to sort the documents first by page count but preserving the master/dupe grouping. Any documents which don't belong to a set or are just a duplicate without a master i want at the end of my set but also ordered by page count.

Here's an example set that I would want to order by:

DocumentId Page_Count SetId Is_Master
2002 2 1 0
2003 20 2 0
2008 20 NULL NULL
2010 20 4 0
2012 1 4 1
2001 5 1 1
2004 16 3 1
2011 17 4 0
2014 10 5 0
2009 9 NULL NULL

As you can see I have a little bit of everything here. Docs 2001 and 2002 are the typical set of 1 master and its duplicate. Docs 2010, 2011, and 2012 is the same just a set of 3. Doc 2004 is a master but without any duplicates. Docs 2003 and 2014 are duplicates without a master (these docs have a master in the table but that doc isn't in the set i need to order by). Docs 2008 and 2009 do not belong to a set and as such do not have a master/dupe type.

The result i'm looking to achieve will be ordered as follows:

DocumentId Page_Count SetId Is_Master
2012 1 4 1
2011 17 4 0
2010 20 4 0
2001 5 1 1
2002 2 1 0
2004 16 3 1
2009 9 NULL NULL
2014 10 5 0
2003 20 2 0
2008 20 NULL NULL

As I said above I first want to get the groupings of master/dupes and order ascending on the masters page count. For each duplicate of a master I then want to order the duplicates by page count. After I finished ordering all the master/dupe groups I then want to move on to the rest of the documents which will contain documents that don't belong to a set along with documents which are duplicates but have no master in my set. However, documents which are masters but without duplicates should have been ordered along with the other master/dupes groupings.

With this all in mind I have just been completely overwhelmed as to where to even start. Am I using analytic functions? Hierarchical stuff?

View 10 Replies View Related

Forms :: 2 Different Form To Pass Values From One Form To Another

Mar 11, 2010

is there any type of veriable used in declate statement whith could be used in 2 different form to pass values from one form to another.

View 1 Replies View Related

SQL & PL/SQL :: Ordering The Result Set Based On Input Parameter

Aug 2, 2013

I need to order the result set with different data types based on the input parameter.

select * from scott.emp sc order by decode('&input_parameter',1,sc.empno,2, sc.ename);

If the input_parameter is equals to 1 then,ordering should be based on EMPNO which is Number data type.
If the input_parameter is equals to 2 then,ordering should be based on ENAME which is Character Data type.

Above query was failed for input_parameter 2,as we know that decode should return same data type.

View 6 Replies View Related

Reports & Discoverer :: Ordering Columns And Rows In A Matrix Report

Jun 20, 2012

I am having a matrix report, which has its column cells from table A and row cells from table B when I run the report the columns and rows are not ordered I wrote the order by statement in the report query but there was no defference.

I also wrot a subquery like

select column1, column2, (select column3 from table1 order by code)
from .... but it seems I can not order in a subquery

Is there any way to do that

View 5 Replies View Related

Performance Tuning :: Explain Plan Analysis - Execution Ordering

Jul 21, 2010

I have two Oracle instances that are setup identically.When I run a query on one of them, it takes around 3 seconds, on the other it takes around 200 seconds.

I have looked at the explain plans, and it has shown me what I think is the problem. On one instance, it does a join on two tables, then runs the other filter/access predicates. On the other instance it runs the filter/access predicated first, then does the expensice join. The one that does the join first is the one that takes around 200 seconds. How to tell Oracle to make this join after runnning the other predicates?

View 15 Replies View Related

Forms :: Any Way To Load A Form Within A Form

May 21, 2010

I have a requirement, is there any way i can achieve the following User Interface using oracle forms

Left Pane: Navigation (Tree Menu)
Right Pane: Based on the node clicked in the Tree Menu, a specific form will be loaded on the right.

The tricky part, is there any way i could load a form within a form ? If i make use of OPEN_FORM, it will open a form in its own window.

View 2 Replies View Related

Forms :: How To Open Another Form Within A Form

Dec 20, 2012

I want to convert my forms6i application into forms9i therefore I initially converted my login and explorer form.

In my login form, I am using NEW_FORM to close my login form and wants to activate my explorer form but every time a pop-up raised and asked "DO YOU WANT TO CALL THE NEW FORM?", if I pressed YES then pointer moved to explorer form.

This form is working perfectly in 6i and didn't asked anything and moved to successfully to explorer form.

View 2 Replies View Related

Forms :: Pre-form And When-new-form-instance?

Mar 1, 2010

What is the difference and significance of

1) Pre-form and When-new-form-instance?
2) Post-text-item and When-validate-item?

View 5 Replies View Related

Reports & Discoverer :: How To Create Parameter Form In Descriptive Format

Jan 28, 2013

I have developed report in reports9i and executing this report at application server but the parameter form is not displaying as its displayed in report builder.

parameter form isn't in descriptive format like you can check the department field. how to create parameter form in descriptive format or I am doing any mistake?

View 3 Replies View Related

Application Express :: How To Create A Display Field In Tabular Form

Oct 1, 2012

I am stuck at point.

using apex 4.1, created tabular form for inserting values from customer with a simple query

table name : customer
select
USER_ID ,
USERNAME,
PASSWORD,
STATUS,
PRODUCT_ID
from CUSTOMER

I WANT TO FETCH THE NAME OF PRODUCT FROM ANOTHER TABLE NAME PRODUCT_NAME, I WANT THAT WITH TABULAR FORM COULMN OF PRODUCT NAME IS ALSO DISPLAYED, HOW I DID THAT ? JUST WANT TO ADD COLUMN FROM ANOTHER TABLE IN TABULAR FORM.

WHEN I ADD TABLE NAME IN FIRST QUERY IT IS NOT WORKING GIVING ERROR ABOUT NOT JOINING THE TABLE

View 2 Replies View Related

Application Express :: Coding Stored Procedure - Create Material IN And OUT Form

Nov 21, 2012

I have to develop an application for a store, where some material In and Out on daily basis. and i want to see current status any time.

How to do that means coding of stored procedure, on whose basis i can create material IN and OUT form.

View 0 Replies View Related







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