Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CLOSE INDEXES close structural indexes!
Message
From
23/12/2007 11:00:59
 
 
To
23/12/2007 10:42:39
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:
01277229
Views:
13
>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.

What does it say if you try to SET ORDER TO again (right after the CLOSE INDEXES)?
Just thinking that the structural index may still be open but set to no order by te command.

good luck
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform