OraFAQ Forum: Forms » Problem with List Item

Home » Developer & Programmer » Forms » Problem with List Item (6i)

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

Problem with List Item [message #471396]

Fri, 13 August 2010 18:54

Yanamalai
Messages: 1
Registered: August 2010
Location: USA

Junior Member

I need to filter records in a datablock based on Yes or No criteria.So i created a listitem(INCLUDE_ZERO_QTY_ITEMS) for that and i am using following code in WHEN-LIST-CHANGED trigger.

BEGIN
IF :XGEC_SW_ITEM_LOAD_ITEM_DETS_V.INCLUDE_ZERO_QTY_ITEMS = 'Y'
THEN
GO_BLOCK ('XGEC_SW_ITEM_LOAD_ITEM_DETS_V');
SET_BLOCK_PROPERTY ('XGEC_SW_ITEM_LOAD_ITEM_DETS_V',
default_where,
'1=1');
EXECUTE_QUERY;
ELSIF :XGEC_SW_ITEM_LOAD_ITEM_DETS_V.INCLUDE_ZERO_QTY_ITEMS = 'N'
THEN
IF :XGEC_SW_ITEM_LOAD_ITEM_DETS_V.EXHIBITOR_COUNT = 0
AND:XGEC_SW_ITEM_LOAD_ITEM_DETS_V.SHOW_ORGANIZER = 0
THEN
GO_BLOCK ('XGEC_SW_ITEM_LOAD_ITEM_DETS_V');
SET_BLOCK_PROPERTY (
'XGEC_SW_ITEM_LOAD_ITEM_DETS_V',
default_where,
'1=1 AND EXHIBITOR_COUNT<>0 AND SHOW_ORGANIZER<>0'
);
EXECUTE_QUERY;
END IF;
END IF;
END;

I am able to filter the records but the list item is not displaying initial value and the value that i am selecting from poplist.

can any one help me on this please?