Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CANDIDATE() Function??
Message
De
29/12/1999 13:21:45
 
 
À
28/12/1999 14:16:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00309009
Message ID:
00309968
Vues:
35
>>>>The tag does indeed show to be be a candidate in the table designer. Yet still get false when giving the candidate command. However, it appears that when I changed the type of tag to candidate, it changed the tag number from 2 to 8. When I issue the CANDIDATE(8) command I get .T. Thanks for the help
>>>
>>>Yup, changing the type of tag basically recreates the tag. The tag number is the order that the tag was created.
>>
>>THANKS. One more question...When the tag is set as CANDIDATE, I get an error "Violates Key Uniqueness" when I create a new record in that table. What am I missing regarding the candidate type tags?
>>
>>jd
>
>Candidate keys enforce uniqueness as do primary keys. the record you are adding contains a value that already exists in the table (remember to check deleted records as well).

I am simply appending a blank record to the table. VFP will not permit the blank record to be created because (I am assuming) the field with the CANDIDATE TAG is blank when it is initially created. This would mean I would have to remove the CANDIDATE tag from the field, create the new record, and then add the CANDIDATE tag back in???

Thanks for you halp thus far - still a little fuzzy.

jd
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform