Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00810874
Message ID:
00810887
Views:
11
>>Unique keys really don't have much to do with unique records. They really mean that only one key will be stored in the
>>index, but multiple records may have the same key. What you want is a candidate index.
>>
>>Whoops, candidate indexes are not available for free tables, only tables in a DBC.
>
>Whoops again. :-)
>
>
CREATE TABLE fred (iKey i)
>INDEX ON ikey TAG ikey CANDIDATE
>APPEND BLANK
>APPEND BLANK
Yep, already been called to task on that one.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View