oracle form 6i(search button)

[ranjit.chavan]

hi
any one please tell me how to create search button in oracle forms 6i
and which trigger can use, what code to be written in trigger.

[rampraas]

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.

[rakhatmis]

Hi
i am facing the same problem to search.
i have written the code like this in Post_text_item trigger of my text item where user is entering the search criteria. but i am receiving the error FRM-40737: Illegal restricted procedure GO_ITEM in POST-TEXT-ITEM trigger.
Kindly help me regarding this problem as soon as possible
thanking you in advance