>>>I'm working with VFP6 SP3. In my DBC I have some tables defined with a candidate key. Since one month I have troubles with this candidate keys. The users of my application can save two records with the same candidate key. They are working on Win95 WS and an NT Server.
>>>How can I solve this problem?
>>>
>>>Thanks
>>
>>I have not experienced this behavior. Is it possible your indexes on those tables have become corrupted?
>
>I don't think so. We are working with Stonefield Databases Toolkit.
>We have made a database repair and the problem is still during.
What is the format of the candidate key? A character string? Can you actually see two records in the table with the same key? What happens if you issue the following SQL command:
SELECT CandidateKey, COUNT(*) ;
FROM TableName ;
GROUP BY CandidateKey ;
HAVING COUNT( CandidateKey ) > 1
Chris McCandless
Red Sky Software