Hi Kevin,
It's a good point. I had to create a demo database using some customer data that I wanted to update to a generic format. I wrote a small program with a couple of counters, queried the tabel into a cursor, then updated the table using the cursor pointer as a guide. Not all of the records were updated, and that was in SQL 6.5.
FYI
>Hello,
>
>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
Perry E. Chrzanowski
Programmer/Analyst
Saturn (Solutions) Inc.