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