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:
00810880
Views:
9
>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
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform