SELECT RealTable
DELETE ALL
APPEND FROM TempTable

HTH

>I would like to ask the question again.
>I have a temp table and real table, they have the same structure,fields and number of records. I want to replace or overwrite the whole real table records by the temp table records.
>That will do in runtime. Can the table not in exclussive ? becoz both of the table will be in the form data environment.