From 763a67d39dcb0e5ae49816abcdb9cb7cbc2bd9e0 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期一, 18 五月 2020 10:12:31 +0800 Subject: [PATCH] 2020-05-18 --- src/utils/utils.js | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/src/utils/utils.js b/src/utils/utils.js index 5dc693e..3a918f8 100644 --- a/src/utils/utils.js +++ b/src/utils/utils.js @@ -1141,11 +1141,11 @@ /* 鍚岀被鏁版嵁楠岃瘉 */ Set @tbid='' - Select top 1 @tbid='X' from (select ${item.field}${_primaryKey},1 an n from ${datasource} ) tb inner join (select ID from dbo.SplitComma(@ID@)) sp on tb.${primaryKey}=sp.ID group by ${item.field} having sum(n)>1 + Select top 1 @tbid='X' from (select ${item.field}${_primaryKey},1 as n from ${datasource} ) tb inner join (select ID from dbo.SplitComma(@ID@)) sp on tb.${primaryKey}=sp.ID group by ${item.field} having sum(n)>1 If @tbid!='' Begin - Set @errorcode='E' ,Set @remsg='${item.fieldlabel} 鍊间笉鍞竴' + Set @ErrorCode='E' Set @retmsg='${item.fieldlabel} 鍊间笉鍞竴' goto aaa end ` -- Gitblit v1.8.0