Quote:
Originally posted by sarath
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;
Thanks!! I can't use execute query because there is no master detail relation between the 2 blocks. 1st block is control block where the user enters the criteria for his search ,when the button is clicked it displays thousands of records in the next block which gets data (fields) from 2 different tables which have relation.I wrote cursor to fetch the records (selected fields,not all fields)from 2 different tables.
In the backend (default)it displays records in the ascending order ,so if I set during design time the order by clause for the block property to "csm_Caseno desc" this should display me in the descending order right? But it doesn't do that ,its displaying in the same ascending order in which it is present in the backend.
How do I set the "Orderby" property or
" default_where" property for a block during design time & run time?
I appreciate your help.
Thanks
saritha.
bye
sarath