Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
WHEN CAN I USE PRIMARY KEY?
Message
De
08/05/1998 16:15:31
 
 
À
08/05/1998 15:53:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00098189
Message ID:
00098201
Vues:
28
Just a regular index on Status.HomePhone would do the job. You can't create a primary index on it, since the value are repeated.

HTH

>I still don't know when can I use PRIMARY KEY, I would like to make a permanent relation in DATABASE using the phone number, for example:
>I have two files:
>Customer......................................Status
>name,homephone..............................homephone,status,date
>A 201---------------------------------------201 0 1-1-98
>--------------------------------------------201 2 1-10-98
>--------------------------------------------201 1 1-16-98
>B 203---------------------------------------203 1 2-10-98
>C 205---------------------------------------205 1 2-10-98
>D 112---------------------------------------112 0 2-16-98
>
>when I try to create the index on STATUS file, VFP says uniques of index on PHONES is violated. That means that I can't create a permanent relation?
>How I can do the permanent relation?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform