hi saritha,

after setting the block_property u have to requery
i.e. after button is pressed use execute_query built in.

otherwise the records previously fetched remains static,when
u requery then the new records will be displayed according
to the block property which was set accordingly
try this one


begin
if get_block_property('block_name',order) = 'column_name ASC' then
set_block_property('block_name',default_where,'column_name' DESC');
EXECUTE_QUERY(NO_VALIDATE);
else
set_block_property('block_name',order by, 'column_anmeASC');
EXECUTE_QUERY(NO_VALIDATE);
end if;
end;


bye
sarath