As Nick said, you can index your cursor. However if you're adding records you should probably be using a parameterized view. And with a view you can open the view with no records and run the indexes on the empty view. Then each time your requery the view the indexes are automatically updated to the new data.
If you are using a non-parameterized view, you can open with no data with the NODATA clause or (if the view is in the data environment) with the "NoDataOnLoad" property set to TRUE.
When data is being changed, views are much easier to handle than cursors.
HTH
Barbara
>Hi,
> I have a grid that the recordsource is set to a cursor. And in the form, i will allow to add in new record into the cursor and display in the grid. But i wish to reorder(order by a specific field) the record when i added the record into the cursor.
> Is it got any way to reorder the cursor without reSelect.... into another cursor and set the grid recordsource again ?
>thanks
>
>regard,
>kengwen