Thank you for the feedback Aleksey.
Again, I have additional questions on your feeback.
1. Does this mean that I don't need to call the SQLPREPARE() function?
>You should set "Prepared" property for the view:
>DBSETPROP("viewname","VIEW","Prepared",.T.)
>
2. When parameters change, how do I "prepare" the backend result? Do I issue another DBSETPROP() or CURSORSETPROP() before REQUERY()?
>>Can I use SQLPrepare with remote views as such:
>>
>>
>>* assume a database is open
>>* assume tables: saleshist & prods exist
>>cYearWeeks = "200301#200302#200303"
>>cSQL = "select prodid,prods.name,yearweek,sold from saleshist,prods "+;
>> "where yearweek=?cYearWeek"
>>
>>sqlprepare(oApp.ConnectionHandle,cSQL)
>>cursorsetprop("Prepared", .t., 0)
>>
>>create sql view (cViewName) remote connection (cConnName) shared as &cSQL
>>use (cViewName) in 0 alias myRV
>>
>>alines(aWeeks,cYearWeeks,.t.,'#')
>>for i = 1 to alen(aWeeks)
>> cYearWeek = aWeeks[i]
>> * is sqlprepare useful here?
>> requery("myRV")
>>endfor
>>
ramil
~~ learning to stand still