多表更新问题
我在一个TADOQuery 里打开数据集,然后对其中一个表进行修改保存时出错,怎么解决呢?谢谢!
Query里的SQL如下:
select T_TestMaster.RID,
T_TestMaster.DocID,
T_TestMaster.Rdate,
T_TestMaster.UpdateDT,
T_TestMaster.AgentID,
T_Ogl_Agent.AgentName,
T_TestMaster.Remark
From T_TestMaster Left Join T_Ogl_Agent On T_TestMaster.AgentID = T_Ogl_Agent.RID
我想修改的表为T_TestMaster
错误信息为:
---------------------------
Debugger Exception Notification
---------------------------
Project Project1.exe raised exception class EOleException with message '缺少更新或刷新的键列信息。'. Process stopped. Use Step or Run to continue.
---------------------------
OK Help
---------------------------