>Hi,
> I have a cursor base table which will be shown in grid, how could I set order to it?
>
>Thank you
John, it is not exactly clear what type of cursor do you mean, but:
If you mean the cursor created with SELECT... INTO cursor you may use the ORDER BY clause and have it ordered.
If you mean that you have the cursor in DataEnviromment which is based on the table you can use set Order property for that cursor in the DataEnvironment.
And if you want to change the order in the grid using the cursor as it's RecordSource - you can create temporary index (.IDX) on the field which is the ControlSourse for the grid column you want to order.
HTH,
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison