>>Hi all,
>>
>>I'd like to know if you can index a cursor.
>>
>>TIA
>
>You can, but only once (unless they've changed it recently)
>To get more than one index tag convert the cursor as follows
>SELECT ...
> INTO CURSOR C_Tmp NOFILTER
>SELECT 0
>USE DBF('C_Tmp') AGAIN ALIAS T_Tmp EXCLUSIVE
>USE IN C_Tmp
>
>You know have a fully indexable table, but you'll need to explicity delete the cdx file when you close the cursor.
>HTH
Hmmm... From my experience, indexing creates a file but it's deleted as soon as the cursor is "puffed".
I wasn't in the mood for testing implications with multi-user, so I just create the index with a unique name.
Alexandre Nobre
Alpha Bytes Computer Corp.
Did you know that there are innocent people dying in East Timor?
It helps if you do...
I suppose you don't need glasses if you're able to read this line