1.form开发中活用list,即从表中拉取数据绑定大list
procedure create_index_method_list is rg_name VARCHAR2(40) := 'INDEX_METHOD'; rg_id RECORDGROUP; item_id ITEM; errcode number; begin rg_id := create_group_from_query(rg_name, 'SELECT MEANING,' || 'LOOKUP_CODE' || ' FROM FND_LOOKUP_VALUES_VL' || ' WHERE lookup_type = ''CIH_CIRC_INDEX_METHOD''' || ' and enabled_flag = ''Y''' || ' and nvl(start_date_active, sysdate - 1) <= sysdate' || ' and nvl(end_date_active, sysdate + 1) >= sysdate'); errcode := populate_group(rg_id); if errcode = 0 then item_id := FIND_ITEM('CCI.METHOD'); Clear_List(item_id); populate_list(item_id, rg_id); else RAISE FORM_TRIGGER_FAILURE; end if; end;
2.列表项怎么删除已存在列表
选中列表元素,”ctrl+<“;