Hi,

I am using CursorAdapter for updating tables in SQL Server. It works very well. Except ..

When user does not use the application, my understanding is that the application loses connection to the SQL Server (times out). So what I do is check if the connection handle to the SQL server is still valid, and if not reconnecting to the SQL server. This does not really help with CursorAdapter.

Let me explainon simple example. When user opens a form, the VFP application fills a cursor adapter for a table (say, MyTable). So user can see the values of some record in the CA on the screen. So far, fine. Then user goes to lunch or whatever. Comes back after an hour or 30 minutes. User clicks on Add Record button. The application checks if the SQL Server connection handle is still valid. If not, reconnect to the SQL Server. Then the application adds a record to the Cursor Adapter cursor and then call TableUpdate().
Tableupdate() Fail! My understanding is that it fails because some property of the CursorAdapter has the SQL Server connection handle - before the time out. And even though I/app reconnect to the SQL Server (before Tableupdate()), the "old" handle is invalid. And therefore, Tableupdate() fails.

Which property of the CA should I update with the new SQL Server connection handle, when reconnecting to the SQL Server, so that the tableupdate() would not fail?

TIA

UPDATE. I found a property CursorAdapter.DataSource which is set to the SQL Server connection handle. So this must be it that I need to update. I just need to test it by forcing a SQL connection time out.