Hi Fabio, thanks for the reply,

unfortunatley I do need to support simultaneous Fetching of the records set , so I can't set this property to false.

The following code is the real problem here ;

* begin to download the large recordset
USE MyRemoteView
* now get a handle onto the shared connection
lnhandle=SQLCONNECT('Connection1',.T.)
* test to see if the shared connection is busy, it should be!
llBusy = SQLGETPROP(lnhandle,"ConnectBusy")

in that the statement handle returned from the sqlconnect call is on the same connection handle as the remote view.

However when I use this statement handle the busy status is false when it should be true.

Any further ideas wouldbe appreciated.

Thanks Bernard