OraFAQ Forum: Forms » CLEAR THE LIST ITEM

Home » Developer & Programmer » Forms » CLEAR THE LIST ITEM

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CLEAR THE LIST ITEM [message #393769]

Tue, 24 March 2009 05:30

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.

Report message to a moderator

Re: CLEAR THE LIST ITEM [message #393894 is a reply to message #393769]

Tue, 24 March 2009 17:19

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 11:18:41 CST 2025