>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

Bernard, I understand your problem, but
You want to make to work one what that she does not work.

If you want to use a shared connection with simultaneous Fetching,,
the connection it cannot be busy. A simple contradiction is one.


Fabio