Hi, friend
I have finished selecting the records by where condiction.i want to check whether rs.Field() is empty.
can you help me to express it!
thanks a lot!
grs.MoveFirst
MSChart1.Column = 3
MSChart1.ColumnLabel = "ESTABFAIL"
For m = 1 To NumPoints
MSChart1.Row = m
'there is wrong with below sentence
If grs.Fields(3) = Null Then
MSChart1.Data = 0
Else
MSChart1.Data = grs.Fields(3)
End If
grs.MoveNext
Next m
I have finished selecting the records by where condiction.i want to check whether rs.Field() is empty.
can you help me to express it!
thanks a lot!
grs.MoveFirst
MSChart1.Column = 3
MSChart1.ColumnLabel = "ESTABFAIL"
For m = 1 To NumPoints
MSChart1.Row = m
'there is wrong with below sentence
If grs.Fields(3) = Null Then
MSChart1.Data = 0
Else
MSChart1.Data = grs.Fields(3)
End If
grs.MoveNext
Next m
請先 登入 以發表留言。