Thanks Tamar for your response. I may have to change the code a bit at other places but I feel this will work.
>>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