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