ksql语句问题

cxc_forever

1. select ERP_GY_PTMain.fFigureNumber as fFigureNumber,ERP_GY_PTMain.fRoughNum as fRoughNum,ERP_GY_PTMain.fIsGZJ as fIsGZJ,ERP_GY_PTMain.version as version,ERP_MM_ProductionOrder.fProduceOrderNO as fProduceID,ERP_GY_PTMain.fFigureNumber as fFigureNumber1,ERP_GY_PTMain.fDrawingVersion as fDrawingVersion,ERP_GY_PTMain.fSourceVersion as fSourceVersion,ERP_GY_PTMain.fSourceSmallVersion as fSourceSmallVersion,ERP_GY_PTMain.fStatus as fStatus,ERP_GY_PTMain.fRoughNum as fRoughNum1,ERP_GY_PTMain.fRoughType as fRoughType,ERP_GY_PTMain.fChangeExplain as fChangeExplain,ERP_GY_PTMain.fCuttingSize as fCuttingSize,ERP_MM_ProductionOrder.fTaskType as fTaskType,ERP_MM_ProductionOrder.fOrgName as fOrgName,ERP_MM_ProductionOrder.fPlaner as fPlaner,ERP_MM_ProductionOrder.fProductionStatus as fProductionStatus,ERP_MM_ProductionOrder.fOrderStatus as fOrderStatus,ERP_MM_ProductionOrder.fProjectName as fProjectName,ERP_MM_ProductionOrder.fMaterielCode as fMaterielCode,ERP_MM_ProductionOrder.fEditionCode as fEditionCode,ERP_MM_ProductionOrder.fDeliveryDate as fDeliveryDate,ERP_MM_ProductionOrder.fCustomerToken as fCustomerToken,ERP_MM_ProductionOrder.fManufacturerOrderID as fManufacturerOrderID,ERP_MM_ProductionOrder.fOrderSource as fOrderSource,ERP_MM_ProductionOrder.fProductionUnit as fProductionUnit,ERP_MM_ProductionOrder.fPlannedStartDate as fPlannedStartDate,ERP_MM_ProductionOrder.fPlannedEndDate as fPlannedEndDate,ERP_MM_ProductionOrder.fActualStartDate as fActualStartDate,ERP_MM_ProductionOrder.fRemark as fRemark,ERP_MM_ProductionOrder.fMakeReportPersonID as fMakeReportPersonID,ERP_MM_ProductionOrder.fCustomerBatch as fCustomerBatch,ERP_MM_ProductionOrder.fActualEndDate as fActualEndDate,ERP_MM_ProductionOrder.fStartSequenceNum as fStartSequenceNum,ERP_MM_ProductionOrder.fEndSequenceNum as fEndSequenceNum,ERP_MM_ProductionOrder.fProduceOrderNO as fProduceOrderNO,ERP_MM_ProductionOrder.fAvailableNumber as fAvailableNumber,ERP_MM_ProductionOrder.fPlannedOrderID as fPlannedOrderID,ERP_MM_ProductionOrder.fStdLeadtime as fStdLeadtime,ERP_MM_ProductionOrder.fLeadtimeCompressionRatio as fLeadtimeCompressionRatio,ERP_MM_ProductionOrder.fIncompressibleTime as fIncompressibleTime,ERP_MM_ProductionOrder.fPlanLeadtime as fPlanLeadtime,ERP_MM_ProductionOrder.fProcedurePsnID as fProcedurePsnID,ERP_MM_ProductionOrder.fProductionTime as fProductionTime,ERP_MM_ProductionOrder.fBatchNo as fBatchNo,ERP_MM_ProductionOrder.fScrapNumber as fScrapNumber,ERP_StockArchives.fStockEnglishName as fStockEnglishName,ERP_StockArchives.fNormsType as fNormsType,ERP_StockArchives.fStockName as fStockName,(concat(ERP_StockArchives.fStockName, SQL.chr(10), ERP_StockArchives.fNormsType)) as custom1,ERP_StockArchives_2.fStockName as codename,ERP_MM_ProductionOrder.fResultNum as fNumber,(concat(ERP_GY_PTMain.fSourceVersion, ERP_GY_PTMain.fSourceSmallVersion)) as SourceVersion,SA_OPPerson.sName as OGYcpsn,ERP_GY_PTMain.fCreateTime as OGYcreateTime,SA_OPPerson_5.sName as PPlaner,ERP_TaskBookSon.fRawMaterial as fRawMaterial,ERP_ArchivesTechnics.fCreateTime as CreateTime,ERP_ArchivesTechnics.fApprovalDate as ApprovalDate,ERP_TaskBookSon.fDispatch as Dispatch,(case when SQL.nvl( ERP_MM_ProductionOrder.fDocuNum,'N/A') = 'N/A' then ' ' else concat('手工审理单号：', ERP_MM_ProductionOrder.fDocuNum ) end) as no from ERP_GY_PTMain ERP_GY_PTMain optional join ERP_MM_ProductionOrder ERP_MM_ProductionOrder on ERP_GY_PTMain.fProduceOrderID = ERP_MM_ProductionOrder optional join ERP_StockArchives ERP_StockArchives on ERP_GY_PTMain.fFigureNumber = ERP_StockArchives.fStockCode optional join ERP_StockArchives ERP_StockArchives_2 on ERP_GY_PTMain.fStockArchivesID = ERP_StockArchives_2 optional join SA_OPPerson SA_OPPerson on ERP_GY_PTMain.fCreatePsnName = SA_OPPerson optional join SA_OPPerson SA_OPPerson_5 on ERP_MM_ProductionOrder.fPlaner = SA_OPPerson_5 optional join ERP_TaskBookSon ERP_TaskBookSon on ERP_MM_ProductionOrder.fCustomerToken = ERP_TaskBookSon.fCustomerToken AND ERP_MM_ProductionOrder.fMaterielCode = ERP_TaskBookSon.fMaterielCode AND ERP_MM_ProductionOrder.fEditionCode = ERP_TaskBookSon.fEditionCode optional join ERP_ArchivesTechnics ERP_ArchivesTechnics on ERP_GY_PTMain.fArchivesTechnicsID = ERP_ArchivesTechnics where ERP_GY_PTMain = '4a15f457d10e4813ac380fff8a6b42c8'

复制代码

这句ksql语句在编辑器可以测试成功，能查出数据，但是编辑器点设计按钮的时候出错，包括测试的时候也会出错

jishuang

包括测试的时候也会出错运行时报错？确认源码中生成的ksql是什么？

cxc_forever

jishuang 发表于 2018-9-20 14:49
包括测试的时候也会出错运行时报错？确认源码中生成的ksql是什么？

现在测试不报错了，但是编辑器还是不能点回设计，上面发的，就是编辑器生成的ksql源代码

jishuang

ksql编辑器对比较复杂的ksql检查有问题，不要打开ksql编辑器操作，在源码中写ksql语句