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


ADVERTISEMENT

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

Application Express :: Dynamically Update A Number Field By Summing Of Page Item Values

Jun 28, 2012

I'm trying to update a number field on an apex page by summing up the values of multiple page items. I've tried to follow this tutorial

[URL]........

especially the "Create a Set Value Dynamic Action Using PL/SQL" part.

In the tutorial example they return an page item value P3_SAL multiplied by a multiplier they've determined by another page item's case. What I want to do is much simpler in that I just want to add up multiple page item values and then display them in a number field at the bottom of the page.

so the code I tried to use based on the tutorial is in the tab: Home >Application Builder>Application 103>Page 3>Edit Dynamic Action>Create / Edit Action

Set Type: PL/SQL Function Body

PL/SQL Function Body:

BEGIN
return :P3_ITEM1+P3_ITEM2+P3_ITEM3;
END;

Page Items to Submit: P3_ITEM1,P3_ITEM2,P3_ITEM3

But it gives me an error that I need to declare the identifiers, yet it works if I only use one item and I can perform any arithmetic.

i.e.

BEGIN
return :P3_ITEM1+1000;
END;

View 2 Replies View Related

Forms :: Insert And Update Directly Into Table From Pre Update Trigger Of Block?

May 14, 2010

I have a base table (Table A) block with multiple records displayed. I need to track audits to this underlying table in the following way:

If user updates a field in the block I want the pre-changed record's audit fields to be set and I need to create a copy of the record with the changed values. Basically any changes will result in the record being logically deleted, and a copy record created with the newly changed values.

Tried to implement in the block's pre-update trigger which will call a package to directly update Table A then Insert into Table A, then requery the block. Is there a clean and efficient way to do this?

View 4 Replies View Related

Forms :: Text Item In Oracle Forms

Aug 22, 2010

How to get the value of text item in Oracle forms to pass as a parameter in stored procedure.

View 4 Replies View Related

Application Express :: How To Retrieve Item Help Text From Database

May 23, 2013

I would like to let the customer edit the item help text. Is it possible to retrieve item help text from my own custom database table based via a PLSQL function call or something similar?

View 4 Replies View Related

Forms :: Set Validate Item From LOV To Yes

May 29, 2011

i have a table called equipment containing engine_type_id.in the equipment form that is based on the equipment table, i added a non database item called engine_type.

i added an LOV for the engine type field, so that the user can choose the engine type from the the egine types table. i made the engine type id hidden. and set the validate item from LOV to yes.on post query trigger, i selected the engine type into the nondatabase field.

the form is working properly.

when i push CTRL F11 (query) and scroll, even if i didnt change anything the form builder asks me , do u want to save changes.

View 2 Replies View Related

Forms :: How To Get Menu Item Name

May 5, 2009

I have created a Menu in forms 6i,

I want to get Menu Item Name When i pressed any menu item in runtime..

e.g, i have a menu items like,
MENU1
ITEM1
ITEM2
ITEM3

when i pressed ITEM1 then it should display ' MENU1.ITEM1 ',

how can i get this..?

REMEMBER !! I WANT TO GET MENU ITEM NAME IN RUNTIME , WHICH IS CREATED IN DESIGN TIME.

View 10 Replies View Related

Forms :: Create More Than One LOV To Item?

Feb 19, 2011

how can i give more than one lov item to an item?

View 3 Replies View Related

Forms :: Next-Item Trigger

Aug 16, 2013

I have a multi row form (Order Entry form in E Business Suite). When I enter data in a row and error down the validate-item trigger fires and runs some code to check for duplicates, etc and after the cursor should go down to the next row. It goes back to the original row.

View 4 Replies View Related

Forms :: Go-item Not Working?

Feb 1, 2012

I hab a button:

flag:=show_lov('lov16');
if :block.cliente_no is not null then
go_block('clientes');
execute_query;
go_item('block.codigo');
end if;

it calls a LOV and return a value to :block.cliente_no, then execute a query in block clientes, but cursor doesn`t goes to block.codigo it remains in the button ! Why doesn`t works ? Note: if I insert a message before line go_item('block.codigo'); cursor goes to 'block.codigo' (message('hallo');

View 3 Replies View Related

SQL & PL/SQL :: How To Display Missing Item Names For Each Item Code

Feb 16, 2010

I have a table with the following data.

item_code item_name
101 Pen
101 Pencil
101 Scale
102 Pen

[Code]...

My aim is to display the missing itemnames for each itemcode.

For each ITEM_CODE there should be four items i.e Pen,Pencil,Scale and Marker If any itemcode missed any of the itemnames those records should display in the output.

So the output should be like this

101 Marker Because the item Marker is missed.
102 Pencil Because the items Pencil and Marker are missed.
102 Marker Because the items Pencil and Marker are missed.

For itemcode 103 no records should be displayed because it having all four itemnames.

View 21 Replies View Related

Forms :: Shortcut Key For Textbox Item?

Jul 11, 2013

IF on button label, we use ampercent "&" to make its shortcut then is there anyway to make a shortcut for TEXT BOX ITEM ?

View 4 Replies View Related

Forms :: How To Validate List Item

Nov 22, 2010

I am working on form 6i..

I have developed a form with some text items,a list item and a image item...

list item......account_list(values....company,individual)
text_item..... company_name..
text_item.....image_path...

i have attached a pop up menu to image item... Add image and upload image...

When i click on 'Add image' the image path is getting enabled.. it is fine but when i am changing the account_list i need enable and disable the 'Company_name' text item... How can i achieve this??

I have tried it in when-validate-trigger on account_list...

if account_list=individual then
set_item_property('company_name',enabled,property_false);
else
set_item_property('company_name',enabled,property_true);
end if;

But no use of this....

how can i achieve it??

View 5 Replies View Related

Forms :: Verification Of Item Text?

Mar 19, 2013

I want to make a verification of an item text ,the user must enter a number of length 4. So I created a text item :number(4). and in when-validate-item trigger of this item ,I put this

if length(:block.empno) != 4 then
message('this item must containonly 4 digit');
end if;

=> the problem, when the user entered "0123" ,it should be acceptable !! but this is not the case ...

View 12 Replies View Related

Forms :: Post_change Trigger On Item?

Jul 11, 2011

I am asked to change an existing field (Category_Desc) from a data block (applications) from a current form with a different field (Facility) from another table (Places) that is not used in the current data blocks. How do i do that and how should i populate the data... The common string between the table used in the form (applications) and the non used table (Places) is the ID No.

make this change and also with a possible trigger to generate the data....

View 2 Replies View Related

Forms :: How To Set Text Item Transparent In 6i

Dec 21, 2011

I am having Forms with background image on the canvas. now my problem is, how can i set a text item to be transparent so that the background image can be seen as clear as when there is no text item on it.

View 6 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 :: Dynamic List Item

Sep 7, 2011

how to create dynamic list item ????

View 5 Replies View Related







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