>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

... INTO CURSOR cusmas_srh ORDER BY cusmas->cusno READWRITE
INDEX ON ... TAG ...