Perhaps there is a corrupted index. Try to REINDEX.
>Hello everyone,
>
>I have a table with column "ac_no" as the unique primary key, my program works well with the table for a long time.
>
>But today I find that I cannot locate an account with ac_no='12345'.. I used
> set filter to ac_no='12345'
>but it shows no matching record.. all other records can be located by the set filter command but only this one fail. I can find the record when no filter is set so I'm sure it's not deleted or what.
>
>also, since the ac_no is set unique, i should not be able to append a new record with duplicated ac_no, but i can create a new record with ac_no='12345'
>
>seems foxpro regarded this '12345' as another '12345'..
>
>i wish i have expressed the problem clear enough, do anyone know what is happening with this record? how can I avoid from it?
>
>thank you very much,
>Jimi
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)