>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
Hi,
In my opinion you can use LOCATE FOR with the same efficiency as SEEK command (as Microsoft claim that LOCATE command uses any available index). If you debug your application you could fix what exactly the problem is – you can stop your application and try with different LOCATE FOR variants to see when you record is found. Then you will know what the reason for not finding the existing record is.
Venelina Jordanova
Outsourcing IT Services Ltd.