Thank you for your reply. I do get an error, just like Tariq, that connection was lost. Usually happens when user "sits" on a screen and updates (clicks on Save) after a long period. We will see if anybody can make a suggestion.
Have a great weekend.
>I don't use any CA myself, hopefully someone else can jump in?
>
>>PMFJI, but how do you check for a valid handle when you are using Cursor Adapter? With CA, the cursor gets/loads the records. Then on Tableupdate() the SQL server table is updated. This procedure of calling Tableupdate() is very frequent. Do you check for a valid handle before each and every Tableupdate()?
>>
>>>Before
every attempt to read or write to the server, you must check if you have a valid handle. If not, you must get a new one.
>>>
>>>>Dear Experts
>>>>
>>>>I am using SQLSERVER 2008 with VFP.
>>>>
>>>>When there is no activity, user on workstation face this error message
>>>>
>>>>
>>>>ConnectionWrite(WrapperWrite(0))
>>>>
>>>>As a result connection is lost
>>>>
>>>>How to make connection live in case of no activity.
>>>>
>>>>Please help
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
