Forms :: Populating Non Database Item Via LOV After Query

Dec 1, 2010

I have the scenario where I have a table(table 1) which stores the car code and the meaning of that code. I then have another table (table 2)which just stores the code. My datablock is based on the table which just contains the code(table 2). On my form if the user wishes to populate this field in the record I have a Lov which goes to the table 1 and retrieves the code and the meaning of it.

The code is then returned to the corresponding field in the datablock for table 2. this works fine in adding and editing. the user sees the meaning and whilst selecting from the lov populates the code field behind the scenes and everything works fine. However, my problem is when the user does a query only the code field is populated from table 2 (the code field is hidden to the user) therefore the meaning field is left blank as if there is no data there when in fact this is not the case.

View 2 Replies


ADVERTISEMENT

Forms :: Populating A Value For List Item

May 20, 2010

I created one list item.which is populating values from list item query dynamically.If i select a particular value from list it will create new record.for the new record line i want to display list item as 'complete' (i.e not exists in the list).At this time i don't want the list also.How can i assign value to the list item in this scenario?

View 9 Replies View Related

Forms :: Populating Data In List Item?

Jul 15, 2005

I have created a item, CO_NAME as List Item and list style is Poplist.

I have written following code in when-new-form-instance to populate the data from table to item.

DECLARE
rg_name VARCHAR2(40) := 'COMPANY';
rg_id RecordGroup;

[Code].....

But when I run the form, Oracle Error - FRM-41337:Cannot populate the list from record group.

View 2 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 :: Populating Non Database Column?

Jul 16, 2010

I have a field on a form which is not a database item. The value for this is got by concatenating 3 other fields which are database items but not visible on form. But when i am running the execute query to fetch results into these items I want to concatenate the value in those 3 DB fields and display it in the other non-db field at runtime.

View 2 Replies View Related

Forms :: Update Database Item When Non-database Item Is Manually Updated?

Mar 10, 2011

I am having trouble changing a non-displayed field when a displayed field is changed.

When a user wants to un-assign a territory they want to just null the ID field (non-database item). I then need to null the PIDM field(not visible, database item) for that one record.

I tried this, but I end up putting null on all the records instead of just the one record, which ends up un-assigning all the territories not just the one.

Is there a way to assign the null to the PIDM field associated to the ID field of that particular record.

View 6 Replies View Related

Forms :: How To Use When-validate-item In Enter-query Mode

Oct 14, 2012

I have to create a form and i have to use trigger when-validate-item in enter-query mode . I have read trigger when-validate-item can not use Enter Query Mode . Is there any way to do this when i enter-query?

View 5 Replies View Related

Forms :: List Item From Query With Refresh Button

Apr 19, 2010

i want to make a list item from query..i have a form on emp

the list item is on deptno showing the department name its work fine the form are opened when the user enter the new empno they need a other department

the others users or same user are inserting the department from master form

user open the list item it will not show the inserted values until they have to reopen the form because the trigger code inserted on when new form instance but i need a refesh list when user click on list item without reopen form or any refersh button

View 4 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 :: Populating List Items

Jun 7, 2010

there are 3 radio buttons and 1 list item

i want different options to appear in the list item when choosing different radio buttons.

i've tried to compile the codes and there are no errors.

I dunno what went wrong.

B_DEV IS THE BLOCKNAME
LIST_ITEM IS THE NAME OF THE LIST ITEM
SEVEN_ELEVEN, MANNINGS, GNC ARE THE RADIO BUTTONS NAMES
FOR_BANNERS IS THE RADIO GROUP NAME

the following is my
DECLARE

[Code]....

View 2 Replies View Related

Forms :: Populating A Combo Box From A Table

Mar 26, 2010

I want to populate a combo box using values from a table, I know you can manually enter values in the combo box's property palette using the 'Elements in List' option, but this combo box will have changing values and I would prefer it to come from a table rather than manual entry so that when users add a new staff name to the table it will automatically be in the combo box.

I would need to use a trigger on this combo box, but which is the best to use and im guessing the SQL needed is more than just 'select * from staffname'?

View 6 Replies View Related

Forms :: Update From Non Database Item?

Mar 9, 2010

I am preparing a query form based on one view.it will return the result set based on parameters passed.What i need is i will add 3 non database item in entry mode along with result set.Once the user inputs these 3 fields in non database fields , it should update the relevant records mapped to it in database table. How to do this.

View 19 Replies View Related

Forms :: Populating Detail Records Without Navigation

Feb 8, 2011

I have 2 non data base blocks, these 2 blocks act like master details but there is no relation. In header block i have 2 fields called "Product name" and "Product Type"

in detail block having 2 tab pages one having multi record(20 item number and name displayed on it) another one having single record but it has around 20 image items displayed on it.

My requirement is once i enter the product name and then if i press either "key tab" or "Key Enter" or "Mouse Move" from product name field
into product type field then detail record should be populated automatically without using go_block and go_item.

View 4 Replies View Related

Forms :: Block Is Populating Values From Code

Jul 7, 2011

I want to search values with F11.for example i will enter some value and i will press F11.it should be display that record. That block is populating values from code.

View 6 Replies View Related

Forms :: Populating Form With Calculated Values

Aug 19, 2010

I have a form in which the fields are calculated fields. So i need to populate the form after calculating the values based on a database columns. For example if i have a table as below

COL A | Col B | Col C | Col D
2 3 4 5
3 4 5 6

I have 3 fields on my form which i need to populate such that field1 maps to col A. Field2 value is COL B * COL D for that value of COL A. Field 3 value is COLB * COL D for that value of col A.

I tried something like this

PROCEDURE NAME IS

cursor c1 is SELECT * FROM TABLEL;
begin
go_block('Block1');
clear_block(no_validate);
for i in c1 loop
:BLOCK.field1 := i.COL_A;
[code].......

this fetched all the records for field1 but for field2 and field3 it only calculates and populates the field row.

View 1 Replies View Related

Forms :: Database Block To List Item?

Oct 12, 2010

I have a form which contains two canvas.In the first canvas, i have a data block which contains two columns(database item of both are no). In second canvas i have a list item.

My problem is how to pass the value(s) of this data block to the item list which is present in second canvas.

The requirement user has given is such that the user will enter different categories, and in the second canvas where the main datablock is present, will contain a list item in data block which should show the data entered by the user.

View 1 Replies View Related

Forms :: Display Record On Non Database Item?

Sep 17, 2012

I want to display my query select * from Clinical_Chart_CCHPI in non database item which is 1000 Char. I want to display that query when my forms execute.below is the test case.

Create table Clinical_Chart (Chart_Number Char(12),MR_NO Char(13));
Create table Clinical_Chart_CCHPI (Chart_Number Char(12),serial_number number,Date Date, Remarks Varchar(1000));
--------------------------
insert into Clinical_Chart(1,1);
insert into Clinical_Chart_CCHPI (1,1,01-JAN-

[code]...

I have taken one non database block and my item Test which is non-database too. But no result is coming i have attached JPEG file too.

View 4 Replies View Related

Forms :: Database Item In A Block / Canvas

Jan 24, 2011

I am modifying an existing form and wanted to do this with less number of modifications. The existing form has one checkbox item ( displayed and attached to database)..and its not in use ( was created for some enhancement that never implemented but code is there)..and in the form at several places its mentioned/calculated based on Updatabale/Enable/Queryable/Insert..all properties.

Since I want to use the same position of this check box so ..i simply detached the canvas from this item..it compiles fine but when login into application it gives al those errors like..FRM--item not update able.etc etc..

Is there any property to just hide an item inspite having related codes in the form ?

View 2 Replies View Related

Forms :: Summarized Database Item Must Reside In A Block

Nov 11, 2010

FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes.
Item: TOTAL
Block: SALE_DETAIL
FRM-30085: Unable to adjust form for output.

What can i do ?

View 3 Replies View Related

Forms :: Retrieve Value From Database And Then Print In Display Item?

Jun 29, 2013

i want to retrieve a value from the database and then print in a display item. how can i do it?

this code is the retrieval part but it doesn't work:

DECLARE
num number(10);
BEGIN
SELECT ID_CD
INTO num
FROM cd_details
WHERE price=599;
end;

View 7 Replies View Related

Forms :: Uploading Image Which Is Not Database Item From Operating System?

Sep 13, 2010

uploading an image item which is not a database item from the operating system. I am using forms 10g on db 10g. My platform is windows Vista sp1.

I am trying to use
GO_ITEM('BEEEE');
Set_Custom_Property( 'SALGRADE.BEEEE',1, 'READIMGFILE', 'C:/users/ajayia/Desktop/Beeee.jpg' ) ;

But I just get a blank image on runform. I am using WHEN-NEW-BLOCK-INSTANCE trigger. I have tried it on when-new-form-instance, but also not working. The file am trying to upload is a JPG file format, but i cant find the file type in forms image item property. What can I change it to. Or how to i go about changing it.

View 1 Replies View Related

Forms :: Insert Record In Table When One Of Item In Database Block Is Filled?

Sep 11, 2012

i want to insert a record in table when one of item in database block is filled..from which property i knw my one of field in block is filled or not.

View 2 Replies View Related

Forms :: Auto Populating Records In Other Fields Based On Inventory Number Field

Jul 13, 2011

I am having a problem with auto populating different fields based on inventory no. field.. This is a bug giving to me to work on and i not able to figure out how to populate the other fields.

How to set any triggers for the items to auto populate and i am suppose to finish this work today.

View 2 Replies View Related

Forms :: Filter Hard Coded Values In List Item (Tlist) Based On Value Entered In Text Item

May 22, 2010

I have 2 items in my form:

1) Text Item
2) Tlist

Upon form load, TList will be populated with predefined item. The behavior i am trying to achieve is to have a text item so user could entered specific text which will then filter the values in TList .

View 1 Replies View Related

Forms :: ORA-00000 Normal Successful Completion Error While Populating Data From Master Block To Detail

May 21, 2012

ora-00000 normal successful completion error while populating data from Master block to Detail block in Oracle Forms 11g.

View 6 Replies View Related

Forms :: Move Cursor To Another Item From WHEN-VALIDATE-ITEM

Apr 19, 2012

I need to move to control to another item in a same block from WHEN-VALIDATE-ITEM trigger. [WITH OUT USING ANOTHER TRIGGER]

View 6 Replies View Related

Forms :: Populating Values To Record Group From Multi Record Datablock

Jul 26, 2012

My procedure proc_ex is in when_validate_item trigger

I have one Multi Record data block in my form with values in its items

I need to Populate multi record block values to one Record Group using

add_group_row,
add_group_column,
set_group_char_cell to populate values to record group

Let us suppose my multi record data block looks like

item1 item2 item3 item4
10 20 50 70
25 15 30 45
45 90 47 38
75 25 85 90
30 56 78 80

how to populate these multi record datablock values to Record Group ???..Eagerly waiting for your Replies

View 3 Replies View Related

PL/SQL :: Query For Getting Item Revisions

Feb 12, 2013

The following query took several minutes in an environment with about 7,500,000 item revisions :

SELECT
MIR.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NUMBER
, MIR.ORGANIZATION_ID
, MP.ORGANIZATION_CODE

[Code]....

If changing this query to the following, it takes less than a second:

SELECT
MIR.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NUMBER
, MIR.ORGANIZATION_ID
, MP.ORGANIZATION_CODE

[Code]..

What is the extreme difference in performance between these two queries?

View 3 Replies View Related

Forms :: Query Not In Database Field

Nov 27, 2010

i have a single form three database field

i want when i open a form in exceute mode then only a single field it does not show any data from database

means query not allowed in that particular field

how it is posible

View 1 Replies View Related

Application Express :: After Hiding Item / Its Value Cannot Be Used In Query

Jul 30, 2013

I am using its value in a query by using sql collection array. My requirement is that I need to hide that shuttle. But when I hide the shuttle, its value is not retrived by the query.

View 4 Replies View Related







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