Hi Ramil,
You should set "Prepared" property for the view:
DBSETPROP("viewname","VIEW","Prepared",.T.)
Thanks,
Aleksey.
>Hi all,
>
>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
>