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: