Aaron,

Thank you.

My remote view can return tens of thousands rows, so this waiting will go forever.

Is it possible to cancel the asynch fetching in remote view ?
Is it possible to use commands like

SQLSETPROP(gnHandle, 'asynchronous', .F.)  
SQLCANCEL(gnHandle)

to cancel remote view like cancelling SPT ?

>I check the connection is not busy, if yes, loop around, if no continue like this...
>
>

>SELECT TableA
>	nConnectionHandle=CURSORGETPROP('ConnectHandle')
>	DO WHILE SQLGETPROP(nConnectionHandle, "ConnectBusy") = .T.
>		WAIT "Waiting" TIMEOUT 1
>	ENDDO
>