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)
create sql view (cViewName2) remote connection (cConnName) shared as &cSQL2
use (cViewName2) in 0 alias (cViewAlias2)
ramil
~~ learning to stand still