>>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
I think he will get this even with SET DELETE ON. The fact tat this happens only with DELETE THEN INSERT, says that the DELETE part of the update isn't working (just like the update wasn't working before). This tells me again, that somehow the records in the view are lacking sufficient PK information to relate to a record in the base table, so the DELETE FOR statement finds no records (but the INSERT doesn't need to find base records, so it succeeds).
I think the solution to this problem will come from disecting carefully the contents of the view before the update is run.
Erik Moore
Clientelligence