From f9f3fe537fadd3a5a77895d41e5e4a8862d7aa17 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期五, 29 五月 2020 13:34:28 +0800 Subject: [PATCH] 2020-05-29 --- 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