>Hi all
>
>I have create a view that cannot be updated with the above error. When I open the view designer to change the update tables from "All Tables" to "EXPROJCT", the setting cannot be saved. BTW, the "Send SQL Update" is checked.
>
>I would appreciate if you could advise how I can make the view updatable. The view SQL is as below. Thanks
>
>Best Regards
>
>SELECT exprojct.* , emas.dEmpBirth ,
>emas.dEmpConfirm , emas.cEmpNoEE , emas.dEmpHire ,
>emas.cEmpNm , emas.cEmpNoICNew , emas.cEmpSex ,
>emas.cEmpNm2 , emas.dEmpResign ,
>cproject.cPjtCode , cproject.cPjtTyp ,
>cproject.cPjtDesc2 , cproject.cPjtDesc ,
>cproject.dPjtEnd , cperiod.cPrdCode ,
>cperiod.cPrdGrp , ccompany_0.cComCode ,
>ccompany_0.cComDesc2 , corgunit_0.cOrgCode ,
>corgunit_0.cOrgDesc2 , cpostid_1.cPosID ,
>cpostid_1.cPosDesc2 , cgrade.cGrdCode ,
>cgrade.nGrdLevel , cgrade.cGrdcgroup_FK ,
>caccess.cAcsCode , esrvc.dSrvEnd , esrvc.dSrvWef
>FROM ( ( ( ( ( ( ( ( "SHR!exprojct" INNER JOIN
>"SHR!emas" ON exprojct.cEPjtemas_FK =
>emas.cemas_PK ) LEFT OUTER JOIN "SHR!cproject" ON
>exprojct.cEPjtcproject_FK = cproject.ccproject_PK
>) LEFT OUTER JOIN "SHR!cperiod" ON
>exprojct.cEPjtcperiod_FK = cperiod.ccperiod_PK )
>LEFT OUTER JOIN "SHR!esrvc" ON
>exprojct.cEPjtemas_FK = esrvc.cSrvemas_FK AND
>dEPjtRec >= dSrvWef AND dEPjtRec < = dSrvEnd )
>LEFT OUTER JOIN "SHR!ccompany" ccompany_0 ON
>esrvc.cSrvccompany_FK = ccompany_0.cccompany_PK )
>LEFT OUTER JOIN "SHR!corgunit" corgunit_0 ON
>esrvc.cSrvcorgunit_FK = corgunit_0.ccorgunit_PK )
>LEFT OUTER JOIN "SHR!cpostid" cpostid_1 ON
>esrvc.cSrvcpostid_FK = cpostid_1.ccpostid_PK )
>LEFT OUTER JOIN "SHR!cgrade" ON
>esrvc.cSrvcgrade_FK = cgrade.ccgrade_PK ) LEFT
>OUTER JOIN "SHR!caccess" ON
>emas.cEmpcaccess_FK = caccess.ccaccess_PK
>WHERE cexprojct_PK = ?PKValue AND cEPjtemas_FK =
>?ParentPKValue AND cEPjtRefDoc = ?Findcepjtrefdoc
>AND cEmpNoEE = ?Findcempnoee AND cEmpNm =
>?Findcempnm AND NVL(cComCode,'') = ?FindcComCode
>AND NVL(cOrgCode,'') = ?FindcOrgCode AND
>NVL(cGrdCode,'') = ?FindcGrdCode AND
>NVL(cPrdCode,'') = ?Findcprdcode AND
>NVL(cPjtCode,'') = ?Findcpjtcode

I suggest not to try to update such a view.
Cetin