In my forms(version 9i), list item values showing with ALT + DOWN key combination but I want to change it to only DOWN key.I search this combination in FMRWEB.RES file but there isn't any entry of ALT + DOWN.
View 1 RepliesI 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 .
I have 3 tables in the Oracle database( emp, employee, emp1) which has following record values in it.
empidenamejob
7369, 'SMITH', 'CLERK'
I would like to list these 3 tables thru SQL/PLSQL, having the above record values combination. Also, the name of the columns could be different in all the tables i.e. name could be 'ename' in Emp table , and 'name' in Employee table. Is there way to do this in SQL or PLSQL ?
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.
am facing a Problem in creating display items .First I create a display item and name it ITEM6This Display item will show Department name of employees .I create a Block Level Trigger to invoke this display item .
WHEN-VALIDATE-ITEM
select dname into :ITEM6 FROM DEPT where :EMP.DEPTNO=DEPT.DEPTNO;
In Property Palette I edit following
Data Type : char
canvas :canvas4
Then I save ,compile and Run it successfully .But when i press Execute Query button . It shows me Following error message .
SELECT ROWID,ITEM6,EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO FROM scott.emp
ORA-00904: "ITEM6": invalid identifier
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.
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
How can i apply currency format to the select list values queried from database tables. The data is stored in database in number format. The user wants to see 1000 separator commas in the list item values.
View 2 Replies View RelatedA computation after submit pl/sql function process to trim off the first part of the string (CQ..) within the list manager values. Support for example the list manager contains values such as
CQ..SAMPLE1..TEST1CQ..SAMPLE2..TEST2CQ..SAMPLE1..TEST2
The computation process should trim off the first part(CQ..) and should return the list manager value as SAMPLE1..TEST1SAMPLE2..TEST2SAMPLE1..TEST2 Oracle APEX 4.0.2 is the version and Oracle 10g r2 is the database.
I have a requirement in this format.
These are the scripts for the 2 input tables
CREATE TABLE TMP_split
AS
SELECT 1000 AS grp_id, 'abc' AS ATTRIB, 60 AS PCT FROM DUAL
UNION ALL
SELECT 1000 AS grp_id, 'pqr' AS ATTRIB, 40 AS PCT FROM DUAL;
[Code].....
The output needs to be in this format
key | val | grp_id | pct
------------------------------------------
6~7~8 |DIM_11~DIM21~DIM31 | 1000 | 60
6~7~8 |DIM_11~DIM21~DIM31 | 1000 | 40
6~7~8 |DIM_11~DIM22~DIM31 | 1000 | 60
6~7~8 |DIM_11~DIM22~DIM31 | 1000 | 40
6~7~8 |DIM_11~DIM23~DIM31 | 1000 | 60
6~7~8 |DIM_11~DIM23~DIM31 | 1000 | 40
Is there a good way to dynamically obtain this output either by PL/SQL or by query?
This is a case where combination needs to be used. However, I am not able to arrive at the right algorithm for this
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??
how to create dynamic list item ????
View 5 Replies View RelatedI 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;
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 Relatedi 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.
Is that any function or bult in there to find list item's currently selected index number.
View 4 Replies View RelatedI 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.
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)
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.
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 RelatedI 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 RelatedI 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.
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 RelatedOracle 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.
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.
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]...
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 RelatedI 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.
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
How to get the label (not value) of current selection in a List Item.
View 7 Replies View Related