我有一個呼叫 vb.net 程式來列印 DevExpress 報告的 vb6 程式。這些程式多年來一直運行良好，直到去年在某些個人電腦（這些是全新的個人電腦）上升級到 Windows 10 時。通常列印報告需要大約 2 秒鐘，但在一些新電腦（不是全部）上，當嘗試用 dataAdapter 填充資料表/資料讀取器時，程式會掛起。其他人建議它在 sql 陳述句中存在，即使我們在所有 Windows 7 pc 和大約 5 個 Windows 10 pc 上都遇到了零問題。這僅發生在某些 Windows 10 電腦上。
這條sql陳述句能不能全部清理掉？SwatKey 是最后唯一的變數：
"SELECT WeightCert, [SwatLog].[SwatDate], TareDate, SaleCode, " &
"Species, Qual, SaleDesc, Trucker, TruckNo, TruckState, " &
"TruckLic, TrlState, TrlLic, TruckType, Comments, TareLoad, " &
"ScaleLoad, LoadNo, Logger, LogMethod, Block, Val(Gross) as GrossWt, " &
"Val(Tare) as TareWt, Weight, PrintAvg, Brand, Commodity, SortCode, " &
"Deck, UserInfo1, UserInfo2, EmergencyLevel, ReprintCount, " &
"Reason, LocationName, Addr1, Addr2, OwnerName, LoggerName," &
"Contract, Weighmaster, TT, Reprint, TareoutBarcode, PrintTare, TruckName, " &
"ManualWeight, DeputyName, CertStatus, ReplacedCert " &
"FROM Swatlog INNER JOIN tblTempCert " &
"ON [SwatLog].[SwatDate] = [tblTempCert].[SwatDate] " &
"WHERE [tblTempCert].[SwatDate] = #" & SwatKey & "#"
uj5u.com熱心網友回復：
首先，確保您在 fields 上有索引SwatDate。
接下來，嘗試過濾另一個表：
"WHERE [swatLog].[SwatDate] = #" & SwatKey & "#"
或在兩者上：
"WHERE [tblTempCert].[SwatDate] = #" & SwatKey & "# And [swatLog].[SwatDate] = #" & SwatKey & "#"
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/371211.html