| List Item [message #86158] |
Sun, 05 September 2004 05:07  |
satarupa basak
Messages: 1
Registered: September 2004
|
Junior Member |
|
|
|
How to populate the list item dinamically taking data from a table?If i insert a new record in the table,the list item should be populated with the new data.
|
|
|
|
| Re: List Item [message #86162 is a reply to message #86158] |
Mon, 06 September 2004 00:28  |
omar
Messages: 19
Registered: February 2002
|
Junior Member |
|
|
1.you can either execute a query each time you update or insert a record into the table
code:
V_GrpID RECORDGROUP;
V_Select VARCHAR2(1024);
V_ERROR NUMBER
BEGIN
V_SELECT = "YOUR SELECT STATEMENT";
V_GrpID := CREATE_GROUP_FROM_QUERY('Grp_ListName',V_Select);
V_Error := POPULATE_GROUP(Grp_ListName);
POPULATE_LIST(P_ListName,V_GrpID);
2. you can add each item individually to the list
PROCEDURE ADD_LIST_ELEMENT
(list_name VARCHAR2,
list_index, NUMBER
list_label VARCHAR2,
list_value NUMBER);
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
