Forms :: List Item Label Of Current Selection?
May 9, 2012How to get the label (not value) of current selection in a List Item.
View 7 Replies
ADVERTISEMENT
Forms :: List-item Selection Not Working?
Oct 3, 2012i 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]...
Forms :: Multiple Items Selection In A List Item?
Jan 6, 2011I 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 RelatedForms :: Random Selection From List
Oct 21, 2013i 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 RelatedForms :: How To Avoid (no List Elements Defined For List Item) Error
Sep 27, 2011I 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.
Forms :: Filter Hard Coded Values In List Item (Tlist) Based On Value Entered In Text Item
May 22, 2010I 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 .
Forms :: FRM-30351 / No List Elements Defined For List Item
Oct 30, 2011DECLARE
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
Application Express :: Reset Data Picker Page Item By Selection Page Item
Aug 23, 2012Need 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.
Forms :: Enable Or Disable Current Item In Block?
Feb 1, 2011I have one tabular block on the canvas and there is one check box on this block. I want that when I uncheck this checkbox, one item on the current record gets disabled.
i manage to turn all the records enabled or disabled.
I am attaching a dummy form in which I have tried. Checkbox is acting on field :ecc_no.
The DB table for the same is:
CREATE TABLE ECC_MASTER
(
PARTY_TYPE CHAR(1 BYTE) NOT NULL,
PARTY_CODE CHAR(5 BYTE) NOT NULL,
ECC_NO VARCHAR2(25 BYTE) NOT NULL,
RANGE_DIVISION VARCHAR2(30 BYTE),
EMP_NO NUMBER(4) NOT NULL,
[code]....
Forms :: Barcode Label Printing - Prevent Label From Printing N/V For Null Values?
Jul 8, 2013I have set up a label which interacts with our LIMS system. I have set up variables on this label which pull in attribute values from the available tokens. When the attribute value is null, the label is automatically inserting 'N/V' onto the label.
I would prefer for the variable to appear as a blank field on the label when the attribute value is null in the LIMS. can't find anything in the user's manual. Perhaps there is some setting where you can define what to display for null values. I can't seem to find any information on this.
Application Express :: Page Input Item Label Conditional Style At Run Time
Feb 6, 2013We have an issue after migrating to apex 4.2.1. We have a select list and use another couple of dummy items to be used as its label instead of giving the text value to the LABEL control. Only one of the dummy items is shown as a label for the select list conditionally based on another value. It was working fine with the earlier versions upto 4.1, but with the introduction of grid in 4.2, its now displaying the select list on a new row (ie the lable in one row and the select list on the next row).
However, we really would like to solve this by having a way to display the label of the select list either in "required format style" or as an "optional style". The display style should be determined only at runtime.
Example. Say P100_MY_SELECT_LIST is the select list
The label for this item is "My Select List Label"
I have another dummy item P100_DUMMY
if P100_dummy = 1 then the label "My Select List Label" should be displayed in red and with an * *My Select List LabelOtherwise it should be in black and without * My Select List Label.
Forms :: How To Validate List Item
Nov 22, 2010I 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??
Forms :: Dynamic List Item
Sep 7, 2011how to create dynamic list item ????
View 5 Replies View RelatedForms :: No Data In List Item?
Mar 1, 2011I 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;
Forms :: Populating A Value For List Item
May 20, 2010I 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 RelatedForms :: List Item Becomes Inactive After Using Once
Dec 6, 2012i 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.
Forms :: List Item INDEX
May 21, 2010Is that any function or bult in there to find list item's currently selected index number.
View 4 Replies View RelatedForms :: List Item Not Working In 10g?
Jan 28, 2011I 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.
Forms :: Set_lov_property With Respect To List Item
May 21, 2013I 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)
Forms :: Populating Data In List Item?
Jul 15, 2005I 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.
Forms :: List Item Populates But Not Accepting Value?
Jul 31, 2013i 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 RelatedForms :: Scroll Bar Coming In List Item
Dec 10, 2010I 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 RelatedForms :: Database Block To List Item?
Oct 12, 2010I 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.
Forms :: To Create A Dynamic Item List
Sep 12, 2011i 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 RelatedForms :: Sorting Values In List Item
Dec 15, 2010I 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.
Forms :: Creating List Item With Time?
Jul 9, 2013Oracle 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.
Forms :: Populate Record In List Item?
Aug 6, 2010i 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.
Forms :: List Item Background Color?
Nov 25, 2010In 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 RelatedForms :: Disabled List Item Will Be Enabled Accordingly Just By Clicking
Feb 4, 2013I 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.
Forms :: List Item From Query With Refresh Button
Apr 19, 2010i 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
