>>>How can I get APPEND FROM tablename to append all the records in a table, including records that were inserted after the table was opened.
>>>What I mean is that if I insert a new record into a table, then someone else on the network does an APPEND FROM tablename, they only get the records that were in the table when they first opened the table. Shouldn't it append all records, including the new records?
>>>Allen
>>
>>If table is not buffered then they get all (IOW they get what is on disk).
>>Cetin
>What could cause the local machine to show a record that was inserted, but other users on the network can't get all the records from the APPEND FROM command? The new record will only APPEND FROM when they close the table and reopen it.
The VFP and OS cache.
On VFP9 exists an possible (?) solution:
FLUSH IN tableAlias FORCE
<PRE>
On VFP8 you have none solution
because the API
<pre>
FlushFileBuffers(fHandle)
require the file handle of the table.