vb 读取数据库数据,怎么读出是空值?
我是一个vb的初学者,写了一段读取数据库的代码,但读出全是空值,请高手看看哪里出问题了。
代码如下
Dim RecNum As Integer, I As Integer
On Error Resume Next
Shujuku.Filter = "工程 (*.Mdb)|*.Mdb"
Shujuku.ShowOpen
If Shujuku.FileName <> "" Then
g_ProjectFile = Shujuku.FileName
Set g_MyWs = DBEngine.Workspaces(0)
Set g_d_Base = g_MyWs.OpenDatabase(g_ProjectFile)
Set Arecord = g_d_Base.OpenRecordset("观测数据表", dbOpenTable)
With Arecord
If .RecordCount > 0 Then
Point_MaxNum = .RecordCount
RecNum = Point_MaxNum
.MoveFirst
For I = 1 To RecNum
Obs_Time(I - 1) = .Fields(0)
Point_Name(I - 1) = .Fields(1)
Point_X(I - 1) = .Fields(2)
Point_Y(I - 1) = .Fields(3)
Point_H(I - 1) = .Fields(4)
If I < RecNum Then
.MoveNext
End If
Next I
End If
End With
Arecord.Close
End If