This content has been marked as final. Show 2 replies
In the Search button's WHEN-BUTTON-PRESSED trigger you would probably want to build a where clause for the block below and execute it.
Something like that. BLOCK_NAME would be the name of your actual block that you are querying. Also, instead of "default_where" in the set_block_property, you could use the ONETIME_WHERE statement, but it just depends on how you want to use it. You can always do a help on form builder and lookup SET_BLOCK_PROPERTY to read the differences.
declare v_where varchar2(240); begin v_where := 'dep_id = ' || :control.dep_id; set_block_property('BLOCK_NAME', default_where, v_where); go_block('BLOCK_NAME'); execute_query; end;