Can you provide steps to reproduce this?
Does it happen in the VFP IDE itself, or only in a runtime exe?
Thanks!
>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.
Jim Saunders
Microsoft
This posting is provided “AS IS”, with no warranties, and confers no rights.