Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Non-Structural indexes.???
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00400310
Message ID:
00400515
Views:
13
Hi Ed,

>You can create a non-structural .CDX using the TAG blah OF woof.CDX clause; I haven't checked, but it may be that creating a single index on a read-only cursor results in a non-structural CDX as well; I haven't tested, but it would make sense given the behavior of indexes on cursors from SQL Selects (you can create one index on the result of a SELECT... INTO CURSOR, but to have more than one, you have to reopen the cursor in read/write mode by USE AGAIN, so that the cursor's header can be updated - this would hint at the single index not being a structural index, since it's created without the ability to write into the header of the temporary table.)

Hmm... I don't use the OF clause either... I do index SELECT...INTO CURSOR results at times, but don't recall getting the Non-Structural message on those cursors. Unless VFP isn't really complaining about the indexes on the views. More data-gathering to do. Thanks.
Bill Armbrecht
VFP MCP
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform