Clear_List / Delete_List_item
358186Feb 9 2004 — edited Feb 11 2004Hi...
I need to clear my list item (poplist). The problem is that when I want to do it I have some record queried form the data base in my block. Other time I have clear block at first then I change it (insert some values to items) and then I need to clear my list item.
Forms documentation seys:
"DELETE_LIST_ELEMENT Restrictions:
.
.
.
For a base table Poplist or T-list list item, Forms Developer returns error FRM-41331: Could not delete element from <list_item> if you:
attempt to delete the other values element when the block contains queried or changed records.
attempt to delete any element from a list that does not contain an other values element when the block contains queried or changed records.
Note: The block status is QUERY when a block contains queried records. The block status is CHANGED when a block contains records that have been either inserted or updated (queried records have been modified)."
the restrictions form clear_list are the same as for the delete_list_element.
My question is: Is there any way to clear that list item?? Can I change the block status anyhow?