From a2df1bad33874fc6d9f96b0ceb1a6ce97b2e7e80 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期二, 26 五月 2020 19:35:40 +0800 Subject: [PATCH] 2020-05-26 --- 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