Hi Ramil,

It isn't a good idea to put unrelated questions into the same message. I would suggest that you repost them as separate threads with meaningful titles.

>Hi all,
>
>I thought it would be a good idea to throw these two questions at once. So here goes.
>
>1. Can I use SQLPREPARE for my remote views as such:
>

>sqlprepare(oApp.ConnectionHandle,cSQL)			
>cursorsetprop("Prepared", .t., 0)
>create sql view (cViewName) remote connection (cConnName) shared as &cSQL
>use (cViewName) in 0 alias (cViewAlias)
>

>
>2. Is this the correct implementation of FetchAsNeeded
>

>dbsetprop("cConnName","connection","asynchronous",.t.)
>cursorsetprop("FetchSize", 50, 0)
>cursorsetprop("MaxRecords", 50, 0)
>cursorsetprop("FetchAsNeeded", .t., 0)
>create sql view (cViewName1) remote connection (cConnName) shared as &cSQL1
>use (cViewName1) in 0 alias (cViewAlias1)
>* If I comment this UDF, it will cause a connection busy error
>* Shouldn't the ASYNCH & FetchAsNeeded take care of this?
>* WaitForFreeConnection() && wait until connection is no longer busy
>create sql view (cViewName2) remote connection (cConnName) shared as &cSQL2
>use (cViewName2) in 0 alias (cViewAlias2)
>