Not sure what you're proposing. There are GUI controls bound to the view. I want to reconnect the view to the SQL server, without the controls beeing disconnected from the view.
walter,
>Walter,
>
>Why not just rebuffer the data into a native VFP cursor?
>
>
>USE TheView in 0 alias RemoteViewTemp
>select * from RemoteViewTemp into cursor TheView readwrite
>use in RemoteViewTemp
>
>
>>I'm faced with a thorny problem with remote views (or updatable SPT for that matter). In unreliable networks or workstations that fall into hybernate (sleep) mode the ODBC connection of a remote view is dropped. My application can detect that such event is occuring.