Dim rsSOrder As New ADODB.Recordset
Dim rsTmp As New ADODB.Recordset
Dim strSQL As String
strSQL = "SELECT SOrderID FROM SOrderHead WHERE State='2' AND SOrderID LIKE 'S%' ORDER BY SOrderID"
rsSOrder.Open strSQL, cnWarehouse, adOpenKeyset, adLockReadOnly
lstSOrder.Clear
Do While Not rsSOrder.EOF
strSQL = "SELECT Count(*) FROM SOrderItem WHERE SOrderID='" & rsSOrder.Fields(0).Value & "' AND Quantity>Planed"
rsTmp.Open strSQL, cnWarehouse, adOpenKeyset, adLockReadOnly
If rsTmp.Fields(0) > 0 Then lstSOrder.AddItem rsSOrder.Fields(0).Value
rsTmp.Close
rsSOrder.MoveNext
Loop
Dim rsTmp As New ADODB.Recordset
Dim strSQL As String
strSQL = "SELECT SOrderID FROM SOrderHead WHERE State='2' AND SOrderID LIKE 'S%' ORDER BY SOrderID"
rsSOrder.Open strSQL, cnWarehouse, adOpenKeyset, adLockReadOnly
lstSOrder.Clear
Do While Not rsSOrder.EOF
strSQL = "SELECT Count(*) FROM SOrderItem WHERE SOrderID='" & rsSOrder.Fields(0).Value & "' AND Quantity>Planed"
rsTmp.Open strSQL, cnWarehouse, adOpenKeyset, adLockReadOnly
If rsTmp.Fields(0) > 0 Then lstSOrder.AddItem rsSOrder.Fields(0).Value
rsTmp.Close
rsSOrder.MoveNext
Loop
解决方案 »
- 窗体不响应托盘事件(急~~~)
- VB和sql2000 链接做成了以个管理系统~ 打包后可以在没有装VB和SQL的机器上运行吗?
- 这个问题好像很难,都不会,高手进来看看!
- 比如一个text中的内容为:230&&&&&&& 我只想要230这个值,如何取得?
- vb6应用程序打包后在win98,xp下能安装,在win2000 pro,server下不能更新系统文件,安装失败!!!
- 关于HTTP报头
- 如何删除、修改sqlServer6.5中现有的字段、字段类型?
- 急救中心————关于recordset得一个打开问题
- 一个程序出错的问题
- VB6是否能在WINDOWS2000高级服务器版下安装???
- 关于“82C54 减计数器”难题?
- 问个最笨的问题 关于inet
where a.SOrderID=b.SOrderID
group by b.SOrderID
楼上所说把sorderid 加上索引,怎么做呀^_^
那主要原因是不是
Do While Not rsSOrder.EOF
.......
Loop
这个循环引起的
不要用COUNT