>I am using a cursor for the recordsource of one of my grids. In the header click events I am creating a IDX index to sort the records in the grid which works great, but for some reason I can't get the cursor to hold more than one IDX file. Is this the normal for a cursor to only hold one IDX, or am I doing something wrong? Also if I set the order of the IDX to (DESC) it works fine, but I have to create the IDX index once again to reorder it to ASC. Any help greatly appreciated!!
>
>Thanks.
>
>John.
Hi John
Is this a cursor created by doing some SQL? If it is, then these cursors are in the main created read only and only allow for one index to be created on them. To allow more indexes to be created, you need to make the cursor Read Write. You do this by opening the cursor AGAIN:--
SQL InTo CURSOR MyCursor
USE DBF( 'MyCursor') IN 0 ALIAS ReadWrite AGAIN
USE IN MyCursor &&to close the original
You can now create as many indexes as you like on ReadWrite
HTH
regards
Ian