|
版本: |
|
小版本号: |
|
|
|
数据库: |
|
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
- SELECT ROWNUM AS JUSTEP_RN__, JUSTEP_TABLE__.* FROM (SELECT <font color="#ff0000">ERP_MM_DispatchingRecord.fID</font>,<font color="#dda0dd"> ERP_MM_Groupsublist.fID AS ERP_MM_Groupsublis</font><font color="#ffff00">t</font>, <font color="#ff0000">ERP_MM_ProcedurePlan.fID</font>,
- ERP_MM_ProductionOrder.FBATCHNO AS fBatchNo, OA_AS_Card.FCODE AS fCode,
- ERP_MM_GroupMain.FNAME AS fName, ERP_StockArchives.FNORMSTYPE AS fNormsType, ERP_MM_ProcedurePlan.FPLANNEDENDDATE AS fPlannedEndDate,
- ERP_MM_ProcedurePlan.FPLANNEDSTARTDATE AS fPlannedStartDate
- FROM ERP_MM_GROUPSUBLIST ERP_MM_Groupsublist
- LEFT JOIN ERP_MM_GROUPMAIN ERP_MM_GroupMain ON ERP_MM_Groupsublist.FMAINID = ERP_MM_GroupMain.fID
- LEFT JOIN ERP_ME_WorkCenterMain ERP_ME_WorkCenterMain ON ERP_MM_GroupMain.FWORKCENTERID = ERP_ME_WorkCenterMain.fID
- LEFT JOIN ERP_ME_WorkCenterDetail ERP_ME_WorkCenterDetail ON ERP_ME_WorkCenterDetail.FDOCUMENTNUMBER = ERP_MM_Groupsublist.FPERSONID
- LEFT JOIN ERP_MM_DispatchingRecord ERP_MM_DispatchingRecord ON ERP_ME_WorkCenterDetail.fID = ERP_MM_DispatchingRecord.FRESOURCEID
- LEFT JOIN ERP_MM_ProcedurePlan ERP_MM_ProcedurePlan ON ERP_MM_DispatchingRecord.FPROCEDUREID = ERP_MM_ProcedurePlan.fID
- LEFT JOIN ERP_MM_ProductionOrder ERP_MM_ProductionOrder ON ERP_MM_ProcedurePlan.FPRODUCEORDERID = ERP_MM_ProductionOrder.fID
- LEFT JOIN ERP_GY_PTProcedure ERP_GY_PTProcedure ON ERP_MM_ProcedurePlan.FPROCEDURENUM = ERP_GY_PTProcedure.fID
- LEFT JOIN OA_AS_Card OA_AS_Card ON ERP_MM_Groupsublist.FPERSONID = OA_AS_Card.fID
- LEFT JOIN ERP_StockArchives ERP_StockArchives ON OA_AS_Card.FSTOCKCODE = ERP_StockArchives.FSTOCKCODE
- WHERE (ERP_MM_Groupsublist.FTYPE = '设备') AND (ERP_MM_ProcedurePlan.FIFCOMPLETED <> '是')
- ORDER BY fCode ASC, fPlannedStartDate ASC, fPlannedEndDate ASC) JUSTEP_TABLE__ WHERE ROWNUM<21
复制代码 上面是服务器报错 ,抛出的语句下面的编辑器语句,编辑器执行正常的;
开发版本是Bex5 3.8 部署版本是3.4
a表关联 a b c ,显示 a b c 表ID,a表显示正常 有别名,b c 没有别名!!!!下面标红的地方是a b 表的别名。为什么服务器会把别名编译没了!!!!!!!!!!!已经正常执行3天了,今天突然报错,希望起步解释一下原因!!!
- select ERP_MM_Groupsublist.*,ERP_MM_ProductionOrder.fMaterielCode as fMaterielCode,ERP_MM_ProductionOrder.fEditionCode as fEditionCode,ERP_MM_ProductionOrder.fCustomerToken as fCustomerToken,ERP_MM_ProductionOrder.fBatchNo as fBatchNo,ERP_MM_ProductionOrder.fResultNum as fResultNum,ERP_MM_ProcedurePlan.fActualStartDate as fActualStartDate,ERP_MM_ProcedurePlan.fTransferredQuantity as fTransferredQuantity,ERP_MM_ProcedurePlan.fCompletionQuantity as fCompletionQuantity,ERP_MM_ProcedurePlan.fIFcompleted as fIFcompleted,ERP_MM_ProcedurePlan.fTotalManhour as fTotalManhour,ERP_MM_ProcedurePlan.fSurplusTimes as fSurplusTimes,ERP_MM_GroupMain.fName as fName,OA_AS_Card.fCode as fCode,ERP_StockArchives.fStockName as fStockName,ERP_StockArchives.fNormsType as fNormsType,ERP_ME_WorkCenterMain.fName as gName,ERP_MM_ProcedurePlan.fPlannedStartDate as fPlannedStartDate,ERP_MM_ProcedurePlan.fPlannedEndDate as fPlannedEndDate,ERP_MM_ProcedurePlan,ERP_GY_PTProcedure.fProcedureNameID as pProcedureNameID,ERP_GY_PTProcedure.fCode as pCode,((select (SQL.nvl(sum(ERP_MM_DispatchingRecord.fNumOfWorkers), 0)) as custom2 from ERP_MM_DispatchingRecord ERP_MM_DispatchingRecord where ERP_MM_DispatchingRecord.fProcedureID = ERP_MM_ProcedurePlan)) as custom1,ERP_MM_DispatchingRecord
- from ERP_MM_Groupsublist ERP_MM_Groupsublist
- optional join ERP_MM_GroupMain ERP_MM_GroupMain on ERP_MM_Groupsublist.fMainID = ERP_MM_GroupMain
- optional join ERP_ME_WorkCenterMain ERP_ME_WorkCenterMain on ERP_MM_GroupMain.fWorkCenterID = ERP_ME_WorkCenterMain
- optional join ERP_ME_WorkCenterDetail ERP_ME_WorkCenterDetail on ERP_ME_WorkCenterDetail.fDocumentNumber = ERP_MM_Groupsublist.fPersonID
- optional join ERP_MM_DispatchingRecord <font color="#ff0000">ERP_MM_DispatchingRecord </font>on ERP_ME_WorkCenterDetail = ERP_MM_DispatchingRecord.fResourceID
- optional join ERP_MM_ProcedurePlan <font color="#ff0000">ERP_MM_ProcedurePlan </font>on ERP_MM_DispatchingRecord.fProcedureID = ERP_MM_ProcedurePlan
- optional join ERP_MM_ProductionOrder ERP_MM_ProductionOrder on ERP_MM_ProcedurePlan.fProduceOrderID = ERP_MM_ProductionOrder
- optional join ERP_GY_PTProcedure ERP_GY_PTProcedure on ERP_MM_ProcedurePlan.fProcedureNum = ERP_GY_PTProcedure
- optional join OA_AS_Card OA_AS_Card on ERP_MM_Groupsublist.fPersonID = OA_AS_Card
- optional join ERP_StockArchives ERP_StockArchives on OA_AS_Card.fStockCode = ERP_StockArchives.fStockCode
- where ERP_MM_Groupsublist.fType = '设备' AND ERP_MM_ProcedurePlan.fIFcompleted <> '是'
复制代码
|
|