我公司有個用DELPHI做的收銀系統，現在出了點問題，希望大神可以幫忙解決一下。
該如何解決呢？
uj5u.com熱心網友回復：
代碼怎么傳不上去 再試試
uj5u.com熱心網友回復：
selectB.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
uj5u.com熱心網友回復：
selectB.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
uj5u.com熱心網友回復：
把@var1定義為一個字串，用char(39)+var1+char(39)來拼SQL陳述句就可以。轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/41311.html
標籤：數據庫相關
上一篇：關于delphi 訊息管理
下一篇：求大神幫助，謝謝，不勝感謝！