The following code can create a Cursor(Temp Table) of Actual One.

use MyTable again in 0 Shared
=Afields(MyTableStru)

Create Cursor cMyTable ;
From Array MyTableStru

select cMyTable
Append from MyTable
* To this line, A Cursor carry all data from Real one.

Append Blank
Replace MyKey With "YYZ"

Close All && Should Flush in Real one... but fail ?_?' Nothing add!

I want to know how to:

1. Ensure Flush in Real Table?


2. Avoid Update when Close, Something Like TableRevert()?


3. Ensure retrieve if the Real Table is updated by other?
   Escpecially in 2 or more user add record at the same time!

Or better use Table Buffering (Row, File Lock) instead of Cursor
control??
What are the pons and cons of using Table buffering and Cursor?

Thanks! ^_^"