Sorry Tamar for troubling you but actually there were 2 probs. Another was this EMPTY(&lcVN..&lcPID.) changed it to EMPTY(&lcPID.)

>>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