Forms :: How To Make Block Query

Jan 30, 2012

I have one form, when i press f7 , it says the "The function has no meaning in this context" , how to make it query enabled block.Actually i am going to that block using when button pressed and execute_query.

View 12 Replies


ADVERTISEMENT

Forms :: How To Make Query Mode Work (f11)

Apr 2, 2012

I have created a custom form. I have field called Order No. When i query on Order no.. i should be able to pick order no as well as other fields related to it. how do i acheive this functionality. I mean the f11 and ctrl f11 querying functionality.

View 18 Replies View Related

Forms :: Data Block Using Query?

Mar 1, 2010

I wanna to load data in a data block using sql which using multiple table, views based on condition

View 7 Replies View Related

Forms :: Clear A Block For Enter Query Mode?

Jan 16, 2012

I am using Forms 6i,Oracle 10g. In a form I created, I have 3 blocks, first is a toolbar type with buttons to save, exit etc., other two are one master and detail data block.

how to get the default Oracle toolbar with the buttons, save, delete etc. I dont get in my form.

When the cursor is inside the detail block and then I click on an EnterQuery button in the first block, how do I clear the detail block, using the on btn press code.

What happens when I click the Enter Query button, is that the cursor and current block becomes the button block and when I run the command ENTER_QUERY, no use.

I need to set the block in which the cursor is to be cleared for query, whether it is master or detail, by pressing the button on the first block.

View 7 Replies View Related

Forms :: Enter-Query Mode - One Item In A Block Is Not Getting Cleared

May 24, 2010

I have a form in which there are three blocks A,B and C. When I press F7, the form enters Enter-Query Mode and all blocks clear except block A's one item. Say, Block A has 5 items, Item1, Item2,.. Item5. When I enter Enter-Query mode, Item2 of block A is not cleared and rest all are cleared.

View 2 Replies View Related

Forms :: Query Records Of Detail Block Displayed In Single Row

May 30, 2010

I have a Master block and a Detail Block. They are related using two columns, Document_ID and Page_no. I want to display all the records in master table with corresponding detail records beside them in single line. i.e., as shown below:

MasterItem1 DetailItem1 DetailItem2 DetailItem3

I created the relation between them and executed query. When I execute query in the form, I can find that all the Master Items are displayed in vertical records, but i can only see one record of detail fields. They are displayed as shown below:

mitem1-value1 ditem1value1 ditem1value2 ditem1value3
mitem1-value2
mitem1-value3
mitem1-value4

When the navigate down in master items, then the corresponding detail values are being shown on the same first record.

View 1 Replies View Related

Forms :: Non Database Block Item Value Passing To Query Up Records

Oct 28, 2011

Version information:
Forms [32 Bit] Version 10.1.2.3.0 (Production)
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

When an user enters a value in a field of a Screen, I want to query up the next screen records based on that user input value in the previous screen.The previous screen is based on a control block i.e.

Q_EMP
items- Q_EMP.emp_id, Q_EMP.FY, Q_EMP.hire_flag.

View 3 Replies View Related

Forms :: Can't Navigate Out Of Current Block In Enter Query Mode

May 11, 2010

I have a form with multiple tabs, each tab showing one data block. Many of the blocks are standard in enter-query mode. I want to allow the users to navigate through the tabs while the blocks are in enter-query mode.how can i do this?

View 3 Replies View Related

Forms :: Block Status When User Presses Enter Query Key

Feb 28, 2012

Is it possible to get the status of form or block every time? I mean if user presses Enter query key, it should display some status and if user presses execute query key then it should reflect some status. If user update any then it should reflect.

View 7 Replies View Related

Forms :: Multi Data Block And Checkbox Field Based On Control Block

Nov 19, 2010

i have multi data block filed. and checkbox field which based on control block...My task is when i check checkbox only one field should enabled and my mouse goes to that field

e.g

item11 item21 item31 chkbox1
item12 item22 item32 chkbox2

Scenario like this :

My item field based on data block and checkbox based on control block,while i checked chkbox1 , only item31 on that current record should be enabled and i changed value only on that field

when i checked chkbox1 , my cursor goes to item31...not item32

View 12 Replies View Related

Forms :: Distribute Master Block Total Amount In Detail Block Line Wise

May 5, 2012

i have a master detail form, In Master block we have one field cheque amount and in Detail block we have field receiveable amount invoice wise. if company paid us a cheque amount we will enter this amount in Master block field Cheque amount and in detail block there will be invoice wise receivable amounts. i want to distribute the cheque amount in detail block invoice wise for example

Cheque amount in master block = 291

Invoice wise receiveable amount is as follows

Invoice No , receivable amount , Received amount

10, 196 , 0
20 , 95 , 0
30 , 54 , 0

Result should be as follows:

Invoice No , receivable amount , Received amount

10, 196, 196
20 , 95 , 95
30 , 54, 0

Received amount field should be distributed according to the receivable amount when recevied amount = cheque amount then remaining will be 0.

View 2 Replies View Related

Forms :: How To Read Values In A Multi Record Control Block Using Pre-insert Trigger (block Level)

Jul 24, 2010

I have a multi record control block (basically a text item displaying 6 records) where user enters values and I want to process the values using pre-insert trigger.

I want to read value in each record and then do some tasks using a pre-insert trigger before I commit the values. To navigate between the records I was using first_record, next_record, clear_record built-ins but it gives errors like "40737-illegalrestricted procedure next_record in pre-insert trigger".

View 3 Replies View Related

SQL & PL/SQL :: Possible To Make Query With Analytic Function

Nov 4, 2011

Is it possible to make query with analytic function or somehow to represent output data for next example (sql: ???):

Table: Order
sql: select * from order
Sql output>
Item Barcode Qty
---- ------- ---
1 100100 2
2 100200 1
3 100300 3

Table: Order
sql: ???
Sql output>
Item Barcode Qty ElementarQty
---- ------- --- ---
1 100100 2 1
1 100100 2 1
2 100200 1 1
3 100300 3 1
3 100300 3 1
3 100300 3 1

View 2 Replies View Related

How To Make Index Use In Query Execution

Jun 6, 2013

I have the below query for which ename column has an index. As of my knowledge below queries 1st and 2st will not use index. Hence i used the 3rd statement and that too its not using the index. Finally i used the 4th query, but even the 4th query is not using the index. Then how do i make this query to use my index??? Do i need to create a function based index for this?

1. select * from emp where ename !='BH' ;
2. select * from emp where ename <> 'BH';
3. select * from emp where ename not in ('BH');
4. select * from emp where ename < 'BH' or ename > 'BH';

View 4 Replies View Related

SQL & PL/SQL :: Make Query Like Separate List Of Orders

Mar 1, 2010

I have table called Orders with lots of fields from Imports Fields are ConsigneeKey,Shipto,ProductCode. and another table called Product. Main fields are ProductCode,Price,Weight,StdCube. Now I have two list of Consineekey,One which is shipto X area and another is of Y area. I want to make query like separate list of Orders which is shipto X,Y and Common Products in Both X and Y. I will supply list of Consigneekey in where clause.

View 8 Replies View Related

SQL & PL/SQL :: Improve Procedure Which Is Looping Through Query To Make Inserts

Oct 10, 2013

I am trying to improve a procedure which is looping through a query to make inserts.

FOR P IN (
SELECT O.TYPEID
,o.KEY
,O.ID
,O.NAME
,O.LGNUM
,O.LGNAME
[code]....

View 12 Replies View Related

Reports & Discoverer :: How To Make A Query In Data Model

Jul 6, 2013

I have one report consist of two user parameters like FROMDATAE and TODATE and two queries in data model..

The 1st query is..

SELECT WONO,MCV_DATE,QTY FROM MCSHOP1 WHERE MCV_DATE BETWEEN :FROMDATE AND :TODATE;

It created two user parameters.ie FROMDATE and TODATE.

And 2nd query like this

SELECT MCVN FROM MCSHOP1 WHERE WONO=:WONO OR WONO LIKE 'RW%'||:WONO;

I dont know how to make 2nd query in data model. becoz the WONO will come from 1st query and LIKE command is there..But I tried in formula Column....but it returns more than one row...

View 4 Replies View Related

PL/SQL :: Procedure To Make Minus Query As Output For 2 Tables

Nov 30, 2012

create a procedure so that I could get minus query of 2 table as a result.

I have two table 1- src_table_list ,2- tgt_table_list both tables have 2 columns : serial_no,table_name and 100 records each. and details mentioned in column "table_name" are actually tables name which present in my testing database.

so I need one procedure which will pick one table_name from src_table_list and one table_name from tgt_table_name each time recursively and provide minus query as a result. as below.

select c1,c2,c3,c4 from table1 --(fetched from src_table_list)
minus
select b1,b2,b3,b4 from table2 --(fetched from tgt_table_list)

create the procedure..as I have to prepare minus query for more than 200 tables and then I need to test them for integration testing..

View 11 Replies View Related

Forms :: How To Make A Calendar

Mar 4, 2003

I have read the messages below about making a calendar but am still unsure of how to go about doing this. I have the STNDRD20.OLB file, but I don't know where to put it or what to do with it! What comes next?

View 20 Replies View Related

Forms :: How To Make A Node

Feb 27, 2012

How to make a node of a Hierarchical Tree BOLD without intervene java code ?

View 1 Replies View Related

Parallel Query Block Of Union All Set

Sep 24, 2010

We have very large table having data more than 1000 millions rows. We divide this table into four physical tables say A, B, C and D. The physical horizontal partition of data of this original table is done based upon their business policy.

Each partitioned table has contained data of particular business entity. Further each table has partition and sub partitions based upon business rule.

We have to retrieve data from all these tables as follows:

select a1, a2, a3, a4, a5, a6
from A
where < logical filter condition>
union all
select b1, b2, b3, b4, b5, b6
[code].....

We observed that above each query block execute in serial one after another and individual each query block capable to process data in parallel from respective table.

How does this above query able to execute each query block in parallel?

View 14 Replies View Related

Forms :: Make Calendar In Oracle 10g

Sep 15, 2011

I want to make calendar in oracle form 10g, but i don't know make it. How to do make calendar?

View 2 Replies View Related

Forms :: Make Field Non Editable

Jul 29, 2010

I have a field on the form which is a database field and the value is populated by a LOV. The user should not be able to edit the value selected or enter his own values in the field. Basically the field should only be populated by the lov and should not be editable.

I tried using the SET_ITEM_PROPERTY('XX.XX', UPDATE_ALLOWED, PROPERTY_FALSE); but this only disable update against existing value. If a user selects a new value from LOV that can be edited.

View 8 Replies View Related

Forms :: Make Cursor At The Item

Jan 25, 2013

I have a button "clear" , I want when the button is clicked the items will be cleared and the cursor is at the first item, here is the

:emp.id:=null;
:emp.ename:=null;
:emp.sal:=null;
go_item('emp.id');

=>but the problem that the item changes color, but the cursor remains at the button "clear"

NOTE:
I used the "when-new-item-instance" trigger to change the color of text items

View 3 Replies View Related

Forms :: Make One Form For Many Systems

Mar 4, 2013

make one form for many systems i have (i.e) I need to make it like portal many button for many systems When i enter the button i login to specified system (i.e) I need to make new connection to this schema and disconnect the previous one.

View 1 Replies View Related

Forms :: How To Make Calculator In Oracle 6i Or 10g

Jul 22, 2013

Is it possible to design calculator in oracle forms 6i or 10g?

View 2 Replies View Related

Forms :: How To Make Oracle Application Always On Top

Feb 13, 2010

I want to make oracle application "always active" or "always on top" automatically when windows logon as feature provided in task manager.

View 2 Replies View Related

Pivot Query In Oracle To Get Years From Column And Make Separate Column For Each

Jul 22, 2009

I'm trying to do a pivot query in oracle to get the years from a column and make a separate column for each. I found an example of the code to use on the internet and i changed it for my own tables but i'm getting errors. Namely a "FROM keyword not where expected" error at the beginning of the 'avg(...' statements.

I have copied the code used in

select stud_id, 2006, 2007, 2008, 2009
from (
select stud_id,
avg(case when year=2006 then ((present/poss)*100) else null end) 2006,
avg(case when year=2007 then ((present/poss)*100) else null end) 2007,
avg(case when year=2008 then ((present/poss)*100) else null end) 2008,
avg(case when year=2009 then ((present/poss)*100) else null end) 2009
from attendance.vw_all_attendance_perc
group by stud_id
);

View 11 Replies View Related

Forms :: How To Make Browse Image In Oracle 10g

Apr 17, 2011

how to make browse image in oracle form 10g?

View 1 Replies View Related

Forms :: Make Field Protected Against Update?

Apr 29, 2011

What i am required to do is to protect a field 'COUR_CODE' from update when the SHIP_METHOD='R'. c

if :system.record_status = 'INSERT' then
declare
vcour_code ACCOUNTS.cour_code%type := NULL;
vcourier_account_no ACCOUNTS.courier_account_no%type := NULL;
canvas_name varchar2(30);
begin

[code]....

View 11 Replies View Related







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