Home » Developer & Programmer » Forms » CLEAR THE LIST ITEM
CLEAR THE LIST ITEM [message #393769] Tue, 24 March 2009 05:30 Go to next message
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
Senior Member

DECLARE
LIST_ID ITEM := FIND_ITEM('SEMISTER');
NUM NUMBER:=0;
CURSOR C1 IS
SELECT SEM_DESCRIPTION
FROM SEMISTER
WHERE PROG_CODE = :PROGCODE;

BEGIN
CLEAR_LIST('SEMISTER');
FOR I IN C1 LOOP
NUM := NUM+1;
ADD_LIST_ELEMENT('SEMISTER',NUM,I.SEM_DESCRIPTION,I.SEM_DESCRIPTION);
END LOOP;

END;

-------------------
THIS CODE IS ON WHEN-POST-ITEM BUT LIST IS POPULATE BUT NOT CLEAR THE LIST. ERROR IS FRM-41331 COULD NOT DELETE ELEMENT FROM LIST.
HOW CAN I SOLVED THE PROPBLEM.
HELP ME.
Re: CLEAR THE LIST ITEM [message #393894 is a reply to message #393769] Tue, 24 March 2009 17:19 Go to previous message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
For a Poplist or T-list-style list item, CLEAR_LIST will not clear the default value element or the other values element from the list if they do not meet the criteria specified for deleting these elements with DELETE_LIST_ELEMENT.

When either the default value or other values element cannot be deleted, CLEAR_LIST leaves these elements in the list and clears all other elements.

i found above information in form builder help.
hope it helps you

thanks
jillu
Previous Topic: prevent commit after execute_query
Next Topic: form builder doesnt show compilation errors but unix server does.
Goto Forum:
  


Current Time: Thu Dec 08 02:13:38 CST 2016

Total time taken to generate the page: 0.17427 seconds