Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Error 1491 : No Update Table specified
Versions des environnements
Network:
Windows 2000 Server
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement