Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unique Key question
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00810874
Message ID:
00810887
Views:
10
>>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

Click here to load this message in the networking platform