在使用DataSe数据集时,发现数据表成只读了,原因如下(QQ聊天记录):
鼠中鼠 14:38:50
SELECT
manager1.RealName AS AddUserName,
manager2.RealName AS ModifyUserName,
organization.Id
FROM
organization
LEFT OUTER JOIN manager manager1 ON (organization.AddUserId = manager1.Id)
LEFT OUTER JOIN manager manager2 ON (organization.ModifyUserId = manager2.Id)
这个是没办法输入数据的
鼠中鼠 14:39:15
改成这样就可以了:
SELECT
organization.Id,
manager1.RealName AS AddUserName,
manager2.RealName AS ModifyUserName
FROM
organization
LEFT OUTER JOIN manager manager1 ON (organization.AddUserId = manager1.Id)
LEFT OUTER JOIN manager manager2 ON (organization.ModifyUserId = manager2.Id)
笨笨熊/大兵 14:57:57
位置倒一下?
鼠中鼠 15:01:28
join的字段不能放最前面
鼠中鼠 15:01:44
否则会被当只读表