Hi Lance,
In cases where duplicate matches exist, seek functions will move the record pointer to the first occurance in the file. If you don't want to land on a deleted record then set delete on.
>I am using the indexseek() command to check for duplicate records. Currently, I have a deleted record with a field value of 'C'. I have another record that is not deleted and has a field value of 'C1'. If I rename 'C1' to 'C' the indexseek() command causes the deleted record to be found. Can somebody tell me why this happens and how to get around the problem?
>
>I have set delete='off' and set exact='on'.
>
>Thanks,
>
>Lance
kenweber
GCom2 Solutions
Microsoft Certified Professional