Check the UpdateType property for the view with DBGETPROP(). It sounds like it is set to 2, which is delete and insert. You want it to be 1.
>
>I am having difficulty with a vfp 5.0a app in sql*server 7.0. When I edit an existing record (using remote views) the server seems to be deleting the current record and then inserting a new record. When it hits the tableupdate(.t.,.t.) statement, the delete portion is ocurring, but the insert is not.
>
>I always use Update, but when I changed it to delete and then insert, it worked on a couple of tables -- but not on another. The operation seems very inconsistent. The code works fine with VFP tables, Oracle 7 & 8 and sql*server 6.5 -- but fails on sql*server 7.0.
>
>Anything come to mind that I can check.
>
>Kevin
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05