Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index a Cursor????
Message
From
12/11/1998 18:33:11
 
 
To
12/11/1998 09:39:08
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00156617
Message ID:
00157231
Views:
34
>>>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
Map
View

Click here to load this message in the networking platform