As Christian above said, to do what you are doing, you must set the buffering to 5 - TableBuffering instead of RecordBuffering. Otherwise the CA will try to update everytime you move from record to record. It does not know you have disconnected. This behaviour is present even if you use normal VFP tables, and have RecordBuffering on, the table will be updated when you move from record to record.



>I am purposely issuing SQLDISCONNECT() so we don't maintain connections
>to the server.
>
>
>>Hello again,
>>
>>i assume you have a good reason to disconnect after retrieving data .. so i don't comment on this
>>
>>what you probably fighting with is that if you have BufferMode set to 3 (record buffering) and then SKIP away from one record (but made some changes first)
>>TABLEUPDATE will be executed automatically in the background which of course fails cause you've disconnected from the backend ..
>>
>>so if you want to:
>>get some data
>>disconnect
>>modify many records
>>later reconnect to update them all ..
>>you have to set BufferMode to 5 (tablebuffering) ..
>>
>>Regards
>>Christian