General information
Category:
Coding, syntax & commands
>>>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.
It appears that VFP5 doesn't delete the cdx but VFP6 does, in this situation.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only