This discussion is archived
4 Replies Latest reply: Feb 29, 2008 7:28 PM by RamiahRAGU RSS

Re Set Set_Block_Property DEFAULT_WHERE value

RamiahRAGU Newbie
Currently Being Moderated
I have a Tabular form which have the invoice details with below two Buttons

BTN_QUERY (WHEN-BUTTON_PRESSED) TRIGGER
go_block('BLFRT');
execute_query;
BTN_UNRECEIPT (WHEN-BUTTON_PRESSED) TRIGGER
if :system.mode like 'NORMAL' then
go_block('BLFRT');
Set_Block_Property('BLFRT',DEFAULT_WHERE,' BL_REC_FLAG IS NULL');
execute_query;
end if;
As soon i click BTN_QUERY i get the data in the grid and also when i click BTN_UNRECEIPT also works fine.

the problem is after clicking BTN_UNRECEIPT if i click BTN_QUERY it shows the filtered records and not all the records. i can understand it's because the value is set with BL_REC_FLAG IS NULL. how to clear this and show all records IN BLFRT when i click BTN_QUERY