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) && does this help speed up the query?
>>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
>>