|
Hi,
Try the follwing code.
lv_def_where varchar2(32676);
lv_dum_val varchar2(2000);
begin
lv_dum_val := :blockname.field_name;
lv_def_where := 'Q1='||''''||lv_dum_val||'''';
SET_BLOCK_PROPERTY(DATABLOCK,DEFAULT_WHERE LV_DEF_WHERE); go_item('query_item');
execute_query;
end;
Hope it can be resolved.
With Best,
Rama Prasad K
Dubai.
|