Forms :: List-item Selection Not Working?

Oct 3, 2012

i am facing a problem in functionality of a form as there are different search parameters:
date from: text item-->mandatory
date to: text item---->mandatory
house type: list item-->optional
form_status: list item->optional
order by: list item---->optinal

untill i don't select house type by list item everything is working fine and gives desired result, even with house type if i select any house type result is fine but as i select last list item of house type which is null as i want result without house type then it gives no any data as data is present in database.

for example:
date from: 20-05-2009
date to: 21-05-2009

with these two i got the correct result, then i select
house type: 3

i got the correct result and when i change list item to any value like: 1,2,3.....it is working fine but as i want result without house type by selecting the null value in list item as:
date from: 20-05-2009
date to: 21-05-2009

it is not picking any data from database. but the same search criteria in 1st case as i described above giving result.
declare
qry varchar2(5000);
n number;
alert number;

[code]...

View 5 Replies


ADVERTISEMENT

Forms :: List Item Label Of Current Selection?

May 9, 2012

How to get the label (not value) of current selection in a List Item.

View 7 Replies View Related

Forms :: Multiple Items Selection In A List Item?

Jan 6, 2011

I have a requirement to select multiple values from a list item and do some manipulations with those values. I tried by integrating the LOV with a text item, but couldn't able to select multiple items. Is there a way to do multiple selection in a list item ?

View 1 Replies View Related

Forms :: List Item Not Working In 10g?

Jan 28, 2011

I want to dynamically populate a list item such that the item list should show the name and its value should enter in the background.

I have tried by writing a query in record group, populated it. the list is showing the name in a list item which is not database item. On this List I have written a trigger which is fetching the value to another text item. It is working well but I am not convinced by this method.

for reference, i want if customer select A then list should show balanced and its value is 1when B then list should show lag,lead,advanced... values 2,3,4,.. respectively.

View 3 Replies View Related

Forms :: Random Selection From List

Oct 21, 2013

i have a parameter form where user will input from item to item and items within this range will be come as output , but i want an option to select the random items from the list, like i may not select all the items from 1 to 10 , but instead i want to pick or select randomly , i may opt for 1,3,4 and 7.

View 4 Replies View Related

Forms :: How To Avoid (no List Elements Defined For List Item) Error

Sep 27, 2011

I am creating the Dynamic list but when i am compiling the form it gives the compilation error "No list elements defined for the list item".

I can eliminate it by entering the dummy list element but this dummy value will be displayed at form run time.

View 1 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 :: FRM-30351 / No List Elements Defined For List Item

Oct 30, 2011

DECLARE
CURSOR GRP IS
SELECT RowNum rn, Letter_Group_ID||'-'||A_Desc AName,Letter_Group_ID
FROM Hrs_Group;
BEGIN
Clear_list('Letter_Group_ID');
FOR I IN GRP LOOP
Add_List_Element('Letter_Group_ID',I.rn,I.AName,I.Letter_Group_ID);
end loop;
END;

FRM-30351: No list elements defined for list item.

List LETTER_GROUP_ID

View 4 Replies View Related

Application Express :: Reset Data Picker Page Item By Selection Page Item

Aug 23, 2012

Need to create a report based on date ranges and for this created a interactive report and two page item datepicker fields P15_fromdate and p15_todate. Report works fine with this criteria.But user wants one more field quarter(P15_quarter), When they select the quarter the range values has to get reset and as to get applied to report.

Issue here is unable to find a way to set the page range item values based on the quarter field selection

how to reset the page item fields.

View 0 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

Forms :: Navigation Not Working Using Go Item?

Jan 9, 2012

'm using go_item to open the canvas but the cursor doesnt want to focus on the item. I have to mouse click the item before I can enter any data or tab through it.

View 16 Replies View Related

Forms :: Font Space For Text Item Is Not Working

Mar 9, 2013

I have one text item where i inserted some text . i want to change at run time the text space by using Font_spacing property . This thing is happen by using a push button(trigger when button pressed ). but after clicking the button this is not working.

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

Sep 7, 2011

how to create dynamic list item ????

View 5 Replies View Related

Forms :: No Data In List Item?

Mar 1, 2011

I am populating the list item from predefined record group. the form is running fine but it didnt show the data present in the record group. I have placed the following code in Pre-Form trigger.

declare
list_id item;
rg_id recordgroup;

begin

rg_id := find_group('RECORD_GROUP9');
list_id := find_item('block2.list4');
clear_list(list_id);
populate_list(list_id, rg_id);
end;

View 7 Replies View Related

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 :: List Item Becomes Inactive After Using Once

Dec 6, 2012

i have a form having 5 listitems for making selections. once selecting through listitems i am adding this selection into below datablock by a ok button and saving it into database by a ok button. as i made one selection and press ok buttton it's working fine but after this when i want one more selection through listitems, listitems becomes inactive. it's not working after one selection. my coding on ok button is like this:

begin
select distinct lcode intolcode_ss from vac_view where locality=:vac_view.locality;
select distinct hid intohid_ss from vac_clr_vu where vr_no=:vac_view.vr_no;
:prop_temp.vr_no :=:vac_view.vr_no;
:prop_temp.qtr_type :=:vac_view.qtr_type;
:prop_temp.locality :=:vac_view.locality;
[code]....

may be it's all because of clear_list('vac_view.locality'); but i have to put this as i want to make clear all listitems after making each selections.

View 1 Replies View Related

Forms :: List Item INDEX

May 21, 2010

Is that any function or bult in there to find list item's currently selected index number.

View 4 Replies View Related

Forms :: Set_lov_property With Respect To List Item

May 21, 2013

I have a multiple data block. There is a list item present on the form having three types INVOICE,BOE and MANUAL. When I select 'MANUAL' , that LOV should not appear for a particular item on the form and the user should be able to insert the value manually and validate manually. I did use set_lov_property, but did not get the correct usage.

I think set_item_property with VALIDATE_FROM_LIST property won't work as it sets the same property to whole column once it is fired. So if I write set_item_property for MANUAL it would set the the column, VALIDATE_FROM_LIST property at once when it is fired, not allowing me to the set properties for that column according to INVOICE and BOE where I would require the LOV. I want it to go with the item instance and therefore opting for set_lov_property but not clear with the syntax given

1) SET_LOV_PROPERTY
(lov_name VARCHAR2,
property NUMBER,
value NUMBER);

2) SET_LOV_PROPERTY
(lov_name VARCHAR2,
property NUMBER,
x NUMBER,
y NUMBER)

View 1 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 :: List Item Populates But Not Accepting Value?

Jul 31, 2013

i have a listitem, in which items populates as required but when i select any value out of these populated value, it is not displaying as selected, means i'm unable to select value from that listitem.

View 1 Replies View Related

Forms :: Scroll Bar Coming In List Item

Dec 10, 2010

I have a list item with two values,0 and 1. However when i click on the list item scroll bar appears. My tester is saying for two items she doesn't need a scroll bar.

View 3 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 :: To Create A Dynamic Item List

Sep 12, 2011

i have created a small table which contains only name of cities.On form level i want to create a dynamic list of the name of these cities just by clicking on the textbox without doing any hardcoding.

View 25 Replies View Related

Forms :: Sorting Values In List Item

Dec 15, 2010

I have two list items and from left list item values are populated to right list item through Add and Remove buttons and vice versa.My requirement is

1.) I need to sort the values of list item whenever a new element is added to the list item.

View 1 Replies View Related

Forms :: Creating List Item With Time?

Jul 9, 2013

Oracle Developer Suite 10g

I want to create List item with time .

like in pic when I click on upper side at list item increase time and other side decrease time.

View 1 Replies View Related

Forms :: Populate Record In List Item?

Aug 6, 2010

i want to popultate record in list item.... and write the follwing code...

PROCEDURE POPULATE_REC_IN_COMBO_BOX IS
RG_NAME VARCHAR2(500) :='RGGROUP';
RG_ID RECORDGROUP;
ERRCODE NUMBER;
BEGIN

[code].....

when i call this code then it returns the 2 errors:

1. FRM-41072: Cannot create Group RGGROUP.

2. FRM-41076: Error populating Group.

View 16 Replies View Related

Forms :: List Item Background Color?

Nov 25, 2010

In the attachement, i have one record. if i click on the list_item then it is showing fully blue as background colour, but i want like if i click on the list item then only current value background should show as blue rest of the values white in background colour.

View 1 Replies View Related

Forms :: Disabled List Item Will Be Enabled Accordingly Just By Clicking

Feb 4, 2013

I have a problem in oracle forms. I have a block that displays five records in list item. On load, it will query two data in my table. So the list item (poplist) one and two enabled. (The default of oracle forms - List item one and two are enabled and the rest are disabled because one and two have data).

My problem was, what work around will I gonna do so that if I pressed the mouse in the third list item it will automatically enabled (for a new record) and if I pressed the list item one or two the third item will stay disable (even the fourth and fifth) because simply the user wants to update the item one or two in the list.

View 2 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







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