用系统函数生成报错

dh_n · 发表于 2018-4-17 09:10:19

select ERP_DG_TotalBoxList,ERP_DG_TotalBoxList.version as version,ERP_DG_TotalBoxList.fPackingList as fPackingList,ERP_DG_TotalBoxList.fSoldTo as fSoldTo,ERP_DG_TotalBoxList.fShipTo as fShipTo,ERP_DG_TotalBoxList.fNumber as fNumber,ERP_DG_TotalBoxList.fPhone as fPhone,ERP_DG_TotalBoxList.fMailBox as fMailBox,ERP_DG_TotalBoxList.fStatus as fStatus,ERP_DG_TotalBoxList.fCustomerCode as fCustomerCode,ERP_DG_TotalBoxList.fCurrentActivities as fCurrentActivities,ERP_DG_TotalBoxList.fCurrentExecutors as fCurrentExecutors,ERP_DG_TotalBoxList.fBizStateName as fBizStateName,ERP_DG_TotalBoxList.fBizState as fBizState,ERP_DG_TotalBoxList.fCreatePersonID as fCreatePersonID,ERP_DG_TotalBoxList.fCreateDateTime as fCreateDateTime,ERP_DG_TotalBoxList.foutBoundID as foutBoundID,ERP_DG_TotalBoxList.fSafeKeepingPersonID as fSafeKeepingPersonID,ERP_DG_TotalBoxList.fInBoundDateTime as fInBoundDateTime,ERP_DG_TotalBoxList.fChecker as fChecker,ERP_DG_TotalBoxList.fLnspectionList as fLnspectionList,ERP_DG_TotalBoxList.fCheckDate as fCheckDate,ERP_DG_TotalBoxList.fSignatoryID as fSignatoryID,ERP_DG_TotalBoxList.fSignatoreDateTime as fSignatoreDateTime,ERP_DG_TotalBoxList.fShipVia as fShipVia,ERP_DG_TotalBoxList.fCourierNumber as fCourierNumber,ERP_DG_TotalBoxList.fRemark as fRemark,ERP_DG_TotalBoxList.fIsUsed as fIsUsed,ERP_DG_TotalBoxList.fAttachment as fAttachment,ERP_DG_TotalBoxList.fInvoiceNo as fInvoiceNo,ERP_DG_TotalBoxList.fNETWEIGHTCTN as fNETWEIGHTCTN,ERP_DG_TotalBoxList.fGROSSWEIGHTCTN as fGROSSWEIGHTCTN,ERP_DG_TotalBoxList.fShipVia as fShipVia1,ERP_DG_TotalBoxList.fCourierNumber as fCourierNumber1,ERP_DG_TotalBoxList.fMergeOrderNO as fMergeOrderNO,ERP_DG_TotalBoxList.fTotalPrice as fTotalPrice,(:toChineseMoney( ERP_DG_TotalBoxList.fTotalPrice)) as custom2
from ERP_DG_TotalBoxList ERP_DG_TotalBoxList

复制代码

编码: JUSTEP154115; 提示: KSQL语法错误, DG_TotalBoxList^^.fTotalPrice)中未找到需要的元素, 位置35期望是(