Hi Tamar. I stil have this error:
Error #: 1
Message: File 'v_maccounts.dbf' does not exist.
Line #: 44
Code: SELECT "R" + STR(&lcID.) AS iID, &lcText. AS cName FROM (THIS.cDBCName + "!" + lcVN) WHERE !DELETED() AND EMPTY(&lcVN..&lcPID.) ORDER BY &lcOrder. INTO CURSOR tQuery
Method: buildtree
Object: frmmaccounts.pgf.cntiIDTreeView
>>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