I have a table indexed on an integer field in the "Key" tag with these values:
702065
702066
702067
702068
702069
etc....

The record with the value 702066 in deleted and i Set Deleted On in my program.
If i write (also in Command Window)

Messagebox(Seek(702066,"MyTable","Key"))

It returns the .F. value but the record pointer is not positioned to the end of MyTable (Eof), but on the record after that deleted with the value i searched (702067).

In the fox Guide i read:
"If a match is found, SEEK( ) returns true (.T.), and the record pointer moves to the matching record. If no match is found, SEEK( ) returns false (.F.) and the record pointer moves to the end of the file."

I have no settings on SET NEAR and the default value must be "OFF"

Where is the error.