>Hi all
>
>I have the following logic where THIS.cViewName = "v_mAccounts"
>SELECT "R" + STR(&lcID.) AS iID, &lcText. AS cName ;
> FROM (lcVN) ;
> WHERE !DELETED() AND EMPTY(&lcVN..&lcPID.) ;
> ORDER BY &lcOrder. ;
> INTO CURSOR tQuery
>
>SELECT tQuery
>LOCATE
>
>now when the query runs it asks me to locate v_mAccounts.DBF. How can I get it to understand that v_mAccounts is a view?

Include the database name:

This.cViewName = "MyDatabase!v_mAccounts"

Tamar