Hi,

I have following SELECT statement to select the customer records into a cursor CUSMAS_SRH and order by the customer code,
the cursor is binding to a grid in a form, I want user to click the customer name column header to change the order by customer name,
and click the customer code column header to order by customer code.

How to create the index order for the CUSMAS_SRH ?

SELECT cusmas->cusno,cusmas->cusname FROM cusmas INTO CURSOR cusmas_srh ORDER BY cusmas->cusno

Please advise.

Thanks.
Derek