Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CLOSE INDEXES close structural indexes!
Message
From
23/12/2007 11:37:44
 
 
To
23/12/2007 11:26:29
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01277227
Message ID:
01277233
Views:
24
>>>I have table with order set in Data Environment.
>>>
>>>When I put CLOSE INDEXES on that table it closes structural index on that table.
>>>
>>>Why is that happening?
>>>In Help stands that it doesn't close indexes opened with table.
>>>
>>>I have checked with ORDER() function before and after CLOSE INDEXES.
>>>Before ORDER() it returns order but after CLOSE INDEXES it returns empty value.
>>
>>May I ask WHY you use this command? I have NEVER used this command, I didn't even know it existed. I always use structural indexes, and if I don't need a specific order, I simply use SET ORDER TO.
>
>I have BEGIN TRANSACTION command that requires that indexes must be closed before continuing.

As I wrote, I NEVER use IDX, I ALWAYS use cdx. I suggest that you do the same. I see no reason to use idx, since cdx is faster AND supported during transactions. I think you should see this lack of support for IDX as a clear hint!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform