>I use SQLSTRINGCONNECT() and SQLEXEC() to work with remote data.
>My application re-connects automatically to backend server and
>re-tries the command
>when TCP connection is lost (error is returned from SQLEXEC())
>
>I make SPT cursor updatable using
>
http://www.levelextreme.com/wconnect/wc.dll?LevelExtreme~2,84,14,8150>
>However, after reconnect TABLEUPDATE() returns
>Connection handle is invalid error.
>
>User cannot save the entered data .
>SELECT commands from this connection handle work OK.
>
>Any idea how to fix this ?
Hi
Try SQLIDLEDISCONNECT( nHandle ) before tableupdate and after another connection was possible.