3。建立三个排序程序单元: PROCEDURE sort_asc(blockname varchar) IS BEGIN set_block_property(blockname,order_by,substr(:global.mouseitem,instr(:global.mouseitem,'.')+1,999)); go_block(blockname); execute_query;
PROCEDURE sort_desc(blockname varchar) IS BEGIN set_block_property(blockname,order_by,substr(:global.mouseitem,instr(:global.mouseitem,'.')+1,999) ' desc'); go_block(blockname); execute_query;