My environment:
VFP 7.0 sp1
SQL-Server 2000
ODBC

Problem:
Fatal VFP error C000005 when issuing TABLEUPDATE(.T.) on table buffered cursor created from remote data source.

When I use buffer mode 5 (table buffering) a TABLEUPDATE(.T.) causes a fatal VFP error C000005. With a .T. parameter tableupdate() writes all records. All the records in the cursor are newly appended before I commence with the tableupdate(.T.). I can issue TABLEUPDATE() (with no .T.) so it will update only the current record. I can do this one record at a time. When I get to the last record I get the fatal error. It does not matter which record is the last one I write out. I can skip around the table (even starting with the last record first) issuing tableupdate(), once I get to the last one I get the error. I am using. I have checked to be sure I am not trying to write a record that breaks any SQL-Serv table rules. Ironically when I check SQL-Server tables, all records are written completely even the last one that TABLEUPDATE() failed on.

Thanks for any input you may have.