以下是引用don在2013-7-18 15:38:00的发言:
不明白了!反正我知道:Select 確實列1 + 確實列2 As Size1, 確實列3 As Size2 ,確實列5 From{XXX} 中, Size1不能編輯, Size2 及 確實列5 可以編輯!
上一段代码吧,直接写在SQL2005的视图中 以下所有列都无法在foxtable中编辑
SELECT cstrNo,cstrMaskName, dstrMaskSize, cstrMaskStatus, cdtmStatusDate, cdtmScheduledate, cdtmTargetDate, cdtmTakingDate
FROM (SELECT cstrNo, cstrMaskName, dstrMaskSize, cstrMaskStatus, cdtmStatusDate, cdtmScheduledate, cdtmTargetDate, cdtmTakingDate,
cdtmShippingDate, cdtmReceiveDate
FROM dbo.trsCHGLMaskShippingStatus
UNION ALL
SELECT cstrNo, cstrMaskName, dstrMaskSize, cstrMaskStatus, cdtmStatusDate, cdtmScheduleDate, cdtmTargetDate, cdtmTakingDate,
cdtmShippingDate, cdtmReceiveDate
FROM dbo.trsCHGLTechShippingStatus) AS unn