| Dynamic LOV creation [message #427832] |
Mon, 26 October 2009 01:57  |
shabar
Messages: 20
Registered: October 2009
|
Junior Member |
|
|
Hi
I just add the following code to my WHEN-NEW-FORM-INSTANCE trigger
and added one list item in the property
DECLARE
RG_NAME VARCHAR2(30) := 'RG_LIST';
RG_ID RECORDGROUP;
RET_CODE NUMBER(10);
V_QUERY VARCHAR2(300);
BEGIN
V_QUERY := 'SELECT to_char(AU_CODE) AU_CODE FROM FT_AUTHORS';
RG_ID := FIND_GROUP(RG_NAME);
IF NOT ID_NULL(RG_ID) THEN
DELETE_GROUP(RG_ID);
END IF;
RG_ID := CREATE_GROUP_FROM_QUERY(RG_NAME,V_QUERY);
RET_CODE := POPULATE_GROUP(RG_ID);
POPULATE_LIST('CUSTOMER_ID_LIST_ITEM',RG_NAME);
DELETE_GROUP(RG_ID);
END;
But at run time I couldn't see any items in the list except the item that I have added manually to the list.
If runs following query separately, results also there
SELECT to_char(AU_CODE) AU_CODE FROM FT_AUTHORS
What could be the reason..
rgds
shabar
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
