Posts

Showing posts from March, 2010

Keep Where statement as "default where" when you re query

Scenario : 1- User presses enter query button 2- user enter the criteria and the presses "Execute Query" button 3- Data for the specified criteria is now displayed on the block 4- user wants now to order data ascending , so he presses "Order ASC" button which contains this code "set_block_property('data",default_where,vColumn||' '||'asc'); Execute_query;" 5-The block now displays all the data form the table in a ascending order requirement: user wants to display only the data with the previous specified criteria in an ascending order -------------------------------------------------- DECLARE v_qry varchar2(1000); v_where varchar2(1000); m number; n number; BEGIN csh$block.all_Rec('DATA','QF_BROWSE',:SWITCH,'CSH_ENTER',:ACTION_FLAG); If csh$block.check_records(':browse.status',:action_flag,:switch,'CSH_ENTER','T')>0 then v_qry:=get_block_property('BROWSE',last_qu