Flush is something else (not talking about disk buffers but table buffering). Try this code (using testdata.dbc that comes with VFP):

use employee
cursorsetprop("Buffering",5,"employee")
delete all
insert into employee (emp_id,First_Name) values ("XXX","FirstName1")
insert into employee (emp_id,First_Name) values ("YYY","FirstName2")
browse title "In buffer mode - after edits"
flush
use
use employee
browse title "Closed and opened"

Cetin


>When we click on SAVE we flush all buffers.
>
>>You mean that people don't exist in the child table?
>>If so,
>>Are you sure they was really insert into table ? maybe you worked in buffered mode and miss some tableudate or end transaction command.
>>
>>
>>>We have a parent/child database system.
>>>
>>>Parent is Companies
>>>Child is People
>>>The link is the ID which is manually entered for the company then automatically generated for the people.
>>>
>>>Is there any known way for people to be missing from the people table, if the data was saved?
>>>
>>>I have looked at the table seperately...the names are gone.
>>>I have looked at the deleted records.
>>>The table was NOT packed.
>>>
>>>We did reindex with INDEX ON all the indexes.
>>>We did not kill and recreate the tags.
>>>We did look for the data without any indexes however.
>>>
>>>Is this possible?
>>>Would putting the data into MS SQL make it more secure from the above?
>>>
>>>Glenn