mSQL = "select Rid,Description from jcYwyy where RStyle='" & curRstyle & "'"
Set mRes = grdoCon.OpenResultset(mSQL, rdOpenKeyset, rdConcurReadOnly, rdExecDirect)
If mRes.RowCount > 0 Then
Select Case curRstyle
Case 1
a = "退货原因"
Case 2
a = "退库原因"
Case 3
a = "残次原因"
Case 4
a = "损益原因"
End Select
myNode = treChooseReason.Nodes.Add(, tvwLast, "myNode.Key", "a", 1)
I = myNode.Key
For idx = 1 To mRes.RowCount
Set myNode = treChooseReason.Nodes.Add("i", tvwChild, myNode.Key, mRes("Rid") & mRes("Description"), 1)
mRes.MoveNext
Next
End If
treChooseReason.Nodes(1).Expanded = True
End Sub
在
Set mRes = grdoCon.OpenResultset(mSQL, rdOpenKeyset, rdConcurReadOnly, rdExecDirect)
报错说with变量未设置