>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.
You might use FLOCK() if needed for multiusers, then if successful, just delete all, and append or insert the new records. You'll want to clean up (PACK) the base table occasionally, though, or it'll get bloated with deleted recs...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.