John

Did you create the view in the view designer, if so then create the view in a program using CREATE SQL VIEW AS etc.etc.

Have you downloaded EView from the Downloads section as well, that's a lot better than the standard fox one, and it allows you to amend the SQL.

Kev

>Hi,
>I would like to have a local view as the following:
>
>

>SELECT Tbluserlevel.appid, Tbluserlevel.moduleid, Tbluserlevel.grpid,;
>  Tblusergrp.grpdesc, Tbluser.userid, Tbluser.name, Tbluser.resign,;
>  Tbluser.password, Tblusergrp.lsupervisor, Tbluserlevel.cright;
> FROM  usermgt!tblappmodule INNER JOIN usermgt!tbluserlevel;
>    INNER JOIN usermgt!tblusergrp;
>    INNER JOIN usermgt!tblusrtogrp;
>    INNER JOIN usermgt!tbluser ;
>   ON  Tblusrtogrp.userid+"" = Tbluser.userid+"" ;
>   ON  Tblusergrp.appid+Tblusergrp.grpid = Tblusrtogrp.appid+Tblusrtogrp.grpid ;
>   ON  Tbluserlevel.appid+Tbluserlevel.grpid = Tblusergrp.appid+Tblusergrp.grpid ;
>   ON  Tblappmodule.appid+Tblappmodule.moduleid = Tbluserlevel.appid+Tbluserlevel.moduleid;
> WHERE Tbluser.userid == ?cuserid;
>   AND <B>(Tbluserlevel.appid==?cAppID.OR.EMPTY(?cAppID)=.T.)</B>
>

>However, after I save the view and bring it out again, it become :
>

>SELECT Tbluserlevel.appid, Tbluserlevel.moduleid, Tbluserlevel.grpid,;
>  Tblusergrp.grpdesc, Tbluser.userid, Tbluser.name, Tbluser.resign,;
>  Tbluser.password, Tblusergrp.lsupervisor, Tbluserlevel.cright;
> FROM  usermgt!tblappmodule INNER JOIN usermgt!tbluserlevel;
>    INNER JOIN usermgt!tblusergrp;
>    INNER JOIN usermgt!tblusrtogrp;
>    INNER JOIN usermgt!tbluser ;
>   ON  Tblusrtogrp.userid+"" = Tbluser.userid+"" ;
>   ON  Tblusergrp.appid+Tblusergrp.grpid = Tblusrtogrp.appid+Tblusrtogrp.grpid ;
>   ON  Tbluserlevel.appid+Tbluserlevel.grpid = Tblusergrp.appid+Tblusergrp.grpid ;
>   ON  Tblappmodule.appid+Tblappmodule.moduleid = Tbluserlevel.appid+Tbluserlevel.moduleid;
> WHERE Tbluser.userid == ?cuserid;
>   AND <b>Tbluserlevel.appid==?cAppID.OR.EMPTY(?cAppID)=.T. = .T.</b>
>
>

>
>Different:
>
>Tbluser.userid == ?cuserid;
>AND (Tbluserlevel.appid==?cAppID.OR.EMPTY(?cAppID)=.T.)
>
>with
>Tbluser.userid == ?cuserid;
>AND Tbluserlevel.appid==?cAppID.OR.EMPTY(?cAppID)=.T. = .T.
>
>Any work around?
>
>Thank you