在Delphi中 sV_MySQLT:='SELECT LOCATION, SUM(REQ_QTY-USAGE) iUsage FROM MRLIST1 WHERE ITEM_CODE='''
+DMs.AQ1.FieldByName('ITEM_CODE').AsString
+''' AND STATE NOT IN (''P'',''U'',''X'') AND REQ_QTY > USAGE GROUP BY LOCATION';
DMs.AQT.Close;
DMs.AQT.SQL.Clear;
DMs.AQT.SQL.Add(sV_MySQLT);
DMs.AQT.Open;
iUsage:=DMs.AQT.FieldByName('iUsage').AsFloat;
與在SQL 用存儲過程
SELECT @iUsage=sum(REQ_QTY-USAGE)
FROM MRLIST1 WHERE ITEM_CODE=@iCode
AND STATE NOT IN ('P','U','X') AND REQ_QTY > USAGE
GROUP BY LOCATION
得出的iUsage的值不同是什麼原因?
+DMs.AQ1.FieldByName('ITEM_CODE').AsString
+''' AND STATE NOT IN (''P'',''U'',''X'') AND REQ_QTY > USAGE GROUP BY LOCATION';
DMs.AQT.Close;
DMs.AQT.SQL.Clear;
DMs.AQT.SQL.Add(sV_MySQLT);
DMs.AQT.Open;
iUsage:=DMs.AQT.FieldByName('iUsage').AsFloat;
與在SQL 用存儲過程
SELECT @iUsage=sum(REQ_QTY-USAGE)
FROM MRLIST1 WHERE ITEM_CODE=@iCode
AND STATE NOT IN ('P','U','X') AND REQ_QTY > USAGE
GROUP BY LOCATION
得出的iUsage的值不同是什麼原因?
在SUM(REQ_QTY-USAGE) 与iUsage 之间加‘,’