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