>>>>>>Simple form, one table.
>>>>>>
>>>>>>Set delete is on in the init of that form.
>>>>>>
>>>>>>First record of that table is deleted but is shows in the form.
>>>>>>
>>>>>>When records other than the first one in that table are deleted they don't appear in the form as expected.
>>>>>>
>>>>>>Anyone can help me with this weird behavior?
>>>>>
>>>>>What if you GO TOP of the table after the SET DELETED?
>>>>
>>>>This works... but I don't like it
>>>>
>>>>I never put a GO TOP before in any form. Why the heck that problem occuring now?
>>>
>>>Because current record is cached on VFP internal data.
>>
>>Maybe FLUSH would work ?
>
>I doubt it, and it would be wrong.
>Because the record still exists in the file,
>and a developer must go on to RECALL it,
>the VFP team can not move the record pointer
>without an explicit program command.

Flush as I understand it clears any buffers and writes the changes to disk. Doing that should update the caches. Of course the record would exist as a deleted record. Honestly, I haven't tried it, but if flush works as advertised, it should update the cache and resolve the issue if it is in fact a cache problem as you suggested.