Zafar
asked on
Papulate List item
I have a list item in form and how i can developed it automatically in which trigger. i have a column CITY and want to papulate it ...
ASKER
yes i know i can use when list activated triger but i need code which i have to write..
In general, your code should look something like:
declare
CURSOR main_cur IS
Select column1, column2
From table_name
WHERE ... conditions;
begin
FOR rec IN main_cur
LOOP
ADD_LIST_ELEMENT('list_nam e', 1, rec.column1, rec.column2);
END LOOP;
end;
You could improve it to get rid of any redundant entries and put it in a specific order, but that is the basics.
declare
CURSOR main_cur IS
Select column1, column2
From table_name
WHERE ... conditions;
begin
FOR rec IN main_cur
LOOP
ADD_LIST_ELEMENT('list_nam
END LOOP;
end;
You could improve it to get rid of any redundant entries and put it in a specific order, but that is the basics.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1. Use When-NEW-FORM-INSTANCE
2. When_list_activated
Please let me know if this is not what you are looking for ?