i've tried to display a few records for a particular emp_id.if i wanted to display the records in la_date desc what should i write.
SET_BLOCK_PROPERTY
('leave_appl',DEFAULT_WHERE,'emp_id='||:PARAMETER.teka);
is there ordery by clause in set_block_property?? :confused:
set_block_property
('leave_appl',DEFAULT_order_by,'la_date='||desc);