Originally posted by kmesser
PLEASE don't create mulitple threads for the exact same question.

What I told you before was correct. You can ONLY change the order by setting the order_by clause, they requerying. If that means you have to requery the master table in the master/detail relationship, then do that.

if get_block_property('DETAIL_BLOCK' . . . then
set_block_property('DETAIL_BLOCK' . . .
. . . .
end if;
go_block('MASTER_BLOCK');
execute_query;


I am sorry, it didn't work......
Actually the 1st bock is a control block where the user enters the criteria to query the database. After entering the criteria when he presses the button it takes to the 2nd block which is base table block and fetches the records according to the critria he entered. After the records are fetched into the 2nd block, when the user clicks the button then it should sort the records.
this is what I wrote I know its not the logic....

begin


if (get_block_property('ctrblk', order_by) = 'csm_caseno asc') then
go_block('ctrblk');
execute_query;
set_block_property('casemain', order_by,'csm_Caseno desc');
elsif (get_block_property('ctrblk', order_by) = 'csm_caseno desc') then
go_block('ctrblk');
execute_query;
set_block_property('casemain', order_by,'csm_Caseno asc');
end if ;

can anyone help me....:-(

thanks
saritha