>Cetin,
> I use
>select table
>delete all
>append temptable
>
>but i only can delete the real table records and can't append teh records from the temp table!! actually it already add the record but no data found because i can see the indicator point to the added end records.
>
>regard,
>chang
Chang,
As Sylvain noted you should use "from" and I think you do. Do you mean record pointer is at the eof? If so simply issue "go top", "go %recno%" etc
Cetin