>Hi all
>
>I have the following logic where THIS.cViewName = "v_mAccounts"
>
>
lnSelect = SELECT(0)
>lcVN = THIS.cViewName
>lcID = THIS.cID
>lcPID = THIS.cParentID
>lcText = THIS.cText
>lcOrder = THIS.cOrder
>
>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?
Perhaps you can use the dbf() function to select from the underlying table:
dbf(lcVN)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)