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
>
Andrus