【主数据】客商分配管理单元时提示translate sql exception


错误详细堆栈信息:com.kingdee.bos.BOSException: null
Caused exception message is: translate sql exception, message is
parse error. detail message is :
ERROR. Token's value : first_rows(100) , token's type : Hints, line 1, column 15
source sql is :
select top 50 /*+ first_rows(100) */ 0 as "SELCOL",v."NUMBER",v."NAME",v."SIMPLENAME",v."MNEMONICCODE",v."TAXREGISTERNO",v."ISINTERNALCOMPANY",v."ID",v."BROWSEGROUP.NAME",v."CREATETIME",v."LASTUPDATETIME",v."CREATOR.NAME" from (SELECT "CUSTOMER".FNumber AS "NUMBER", "CUSTOMER".FName_l2 AS "NAME", "CUSTOMER".FSimpleName AS "SIMPLENAME", "CUSTOMER".FMnemonicCode AS "MNEMONICCODE", "CUSTOMER".FTxRegisterNo AS "TAXREGISTERNO", "CUSTOMER".FIsInternalCompany AS "ISINTERNALCOMPANY", "CUSTOMER".FID AS "ID", "BROWSEGROUP".FName_l2 AS "BROWSEGROUP.NAME", "CUSTOMER".FCreateTime AS "CREATETIME", "CUSTOMER".FLastUpdateTime AS "LASTUPDATETIME", "CREATOR".FName_l2 AS "CREATOR.NAME" FROM T_BD_Customer AS "CUSTOMER"
INNER JOIN T_BD_CSSPGroup AS "BROWSEGROUP"
ON "CUSTOMER".FBrowseGroupID = "BROWSEGROUP".FID
INNER JOIN T_PM_User AS "CREATOR"
ON "CUSTOMER".FCreatorID = "CREATOR".FID
LEFT OUTER JOIN T_ORG_CtrlUnit AS "CU"
ON "CUSTOMER".FControlUnitID = "CU".FID WHERE "CUSTOMER".FUsedStatus = 1 AND "BROWSEGROUP".FDeletedStatus = 1 AND "CUSTOMER".FControlUnitID = '00000000-0000-0000-0000-000000000000CCE7AED4') v
【主数据】客商分配管理单元时提示translate sql exception
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



