Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CANDIDATE() Function??
Message
From
29/12/1999 13:21:45
 
 
To
28/12/1999 14:16:51
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00309009
Message ID:
00309968
Views:
36
>>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform