Home » Developer & Programmer » Forms » urgent delete list eliments
urgent delete list eliments [message #86418] Tue, 28 September 2004 21:49 Go to next message
shish mate
Messages: 49
Registered: February 2004
Member
how to del. t-list eliment when u dont know the index number or element selected by user
Re: urgent delete list eliments [message #86422 is a reply to message #86418] Tue, 28 September 2004 22:42 Go to previous message
AB
Messages: 41
Registered: July 2002
Member
The Index cannot be get directly. First you need to find the index by yourself and then use the Delete_list_Element Butiltin.

Eg:
DECLARE
ln_Index NUMBER:=0;
lv_Value VARCHAR2(255):=:BLK.LIST1; --Selected Item Value in the List

FOR i IN 1..GET_LIST_ELEMENT(COUNT) LOOP
IF Get_List_Element_Value('list1',i) = lv_Value THEN
/*Index of the selected item in the List*/
ln_Index = i;
EXIT;
END IF;
END LOOP;
/*Using this Index value delete that element*/
Delete_List_Element('list1',ln_Index);
END;

Regards
AB
Previous Topic: how to delete list eliment when u dont know index number
Next Topic: select query by user
Goto Forum:
  


Current Time: Mon Sep 09 20:47:50 CDT 2024