David,

Does a FLUSH do the trick? What does SET('AUTOSAVE') return?

Note that the Hackers Guide recommends against using the FLUSH command extensively because it says it drags performance down.

Cheers,

Andrew

>>>Has anyone seen this happen?
>>>In an application..
>>>I insert a few records into a small free table, which has one index tag.
>>>Immediately afterward I query the table into which records are inserted in a way which should return all the just inserted records, and all are *except* the very last record inserted are returned!!
>>>If I first "count" or "browse" the table, the subsequent query performs as expected.No buffering etc is in effect.
>>>Looks like VFP is executing faster than the data is getting to disk in this case.
>>
>>If you move the record point off of the newly inserted record, does this help?
>
>Yes it does. That's my work around. But I am worried about where else I might be getting stung.