>Erik,
>
>This is interesting. If I change the update criteria to Update using SQL Delete and Insert. Then I change some records and issue the tableupdate then requery I get the old record and the changed record?!?
>
>So it seems like the SQL Udate is not working correctly.
>
>Any more thoughts?

If you have SET DELETED OFF that would make sense... since the requery() brings you the active and deleted record. Remember, DELETE in xBase files only changes the deleted status.

BOb