Home » Developer & Programmer » Forms » List item dynamic update
List item dynamic update [message #79425] Sun, 09 June 2002 04:59 Go to next message
Sujin
Messages: 1
Registered: June 2002
Junior Member
I have to dynamically update a list item with values from a table and also should be able to enter free text to the same list item. Can someone help?
Re: List item dynamic update [message #79428 is a reply to message #79425] Sun, 09 June 2002 23:40 Go to previous message
Remash
Messages: 52
Registered: November 2000
Member
Hi
You can dynamically update a list item by populating a record group. You can also add elements into the list item. Following are the syntax.

PROCEDURE CLEAR_LIST
(list_id ITEM);

FUNCTION POPULATE_GROUP_WITH_QUERY
(recordgroup_id RecordGroup,
query VARCHAR2);

PROCEDURE POPULATE_LIST
(list_id ITEM,
recgrp_id RecordGroup);

FUNCTION GET_LIST_ELEMENT_COUNT
(list_id Item);

PROCEDURE ADD_LIST_ELEMENT
(list_id ITEM,
list_index VARCHAR2,
list_label VARCHAR2,
list_value NUMBER);

Hope this will help you.
Regards
Previous Topic: Tools for SQL Server SQL to Oracle SQL conversion
Next Topic: ALerts in Forms
Goto Forum:
  


Current Time: Fri Apr 19 22:32:02 CDT 2024