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)