Information générale
Catégorie:
Codage, syntaxe et commandes
>>>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement