小白求助 希望大神们可以帮帮我

[尕齐]

我公司有个用DELPHI做的收银系统，现在出了点问题，希望大神可以帮忙解决一下。




该如何解决呢？

[尕齐]

select B.WJZSHID, B.LXRMC, B.ZH, COUNT(B.LXRMC) SL, SUM(round(A.JSJE_17+A.JSJE_13+A.JSJE_QT+A.ZZSJE_17+A.ZZSJE_13+A.ZZSJE_QT-isnull(A.KKJE_FYHK,0),2)) SFJE from JSD A, WLDW B, HT_LY C where A.WLDW=B.CODE AND A.HTH=C.HTH AND A.HTH<90000000 AND A.JSFKD_JLBH IS NULL group by B.WJZSHID, B.LXRMC, B.ZH having SUM(round(A.JSJE_17+A.JSJE_13+A.JSJE_QT+A.ZZSJE_17+A.ZZSJE_13+A.ZZSJE_QT-isnull(A.KKJE_FYHK,0),2))>@var1 order by B.WJZSHID

[尕齐]

代码怎么传不上去 再试试

[尕齐]

select B.WJZSHID, B.LXRMC, B.ZH, COUNT(B.LXRMC) SL, SUM(round(A.JSJE_17+A.JSJE_13+A.JSJE_QT+A.ZZSJE_17+A.ZZSJE_13+A.ZZSJE_QT-isnull(A.KKJE_FYHK,0),2)) SFJE from JSD A, WLDW B, HT_LY C where A.WLDW=B.CODE AND A.HTH=C.HTH AND A.HTH<90000000 AND A.JSFKD_JLBH IS NULL group by B.WJZSHID, B.LXRMC, B.ZH having SUM(round(A.JSJE_17+A.JSJE_13+A.JSJE_QT+A.ZZSJE_17+A.ZZSJE_13+A.ZZSJE_QT-isnull(A.KKJE_FYHK,0),2))>@var1 order by B.WJZSHID

[并不陌生]

把@var1定义为一个字符串，用char(39)+var1+char(39)来拼SQL语句就可以。