adodb查询到100条记录后,想将ni_num关键字下的所有记录赋给数组
问题:
通过adodb查询到100条记录后,想将ni_num关键字下的所有记录赋给数组。
不知如何实现,求代码
Private Sub GetFgSn()On Error GoTo ErrmsgDim conn As New ADODB.ConnectionDim rs As New ADODB.Recordset Set conn = New ADODB.ConnectionSet rs = CreateObject("adodb.recordset") conn.ConnectionString = "Driver={SQL Server};server=server;database=SuiviTest;uid=test;pwd=test"conn.Open rs.Open "SELECT * FROM dbo.detailMesure where pt_num = '253302739' order by mt_datedeb", conn, adOpenForwardOnly, adLockReadOnlyIf Not (rs.BOF And rs.EOF) Then Debug.Print 2222222Exit SubErrmsg:Debug.Print 1111111End Sub