Since the ConnectHandle is Read-Only, I know of no way to set it to any other connection number. You may of course try and get another connection with the SQLConnect() or SQLStringConnect() functioons and if you get the same number as your original view you should be OK. But that is not a reliable strategy.

You may need to find another way to update your data (if you can re-establish any connection at all).

But the alternatives may require more code than it's worth.

For instance, how about opening up the view again with another alias NODATA and posting the contents of the original view into the second one? Not clean. It will have complications.

Or SPT the specific updates yourself on a different connection. Lots of code?

Guy