Check for key length (trailing / leading blanks) as well as case to assure the source key matches the target key and that SET EXACT ON is implemented
>Dear Everyone,
>My fox application gets a sequence of records (as a string) from another application and checks, using indexes with the "seek" command, whether there already is a record like this in the database. If there isn't one it should insert the new record. In many cases, however, the application enters the record even though it is already there (indexed). If I then apply the command "reindex" I see that the record is duplicated implying that the indexing is not correct.
>
>I would appreciate a response from anyone that can help. Thanks.
>
>Yossi
Imagination is more important than knowledge