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)