vb程序显示 无效使用NULL 麻烦请看错在哪了

来源:百度知道 编辑:UC知道 时间:2024/05/23 17:49:27
Private Sub sjbcx0(mb As Integer, l_AdoConn As ADODB.Connection) '变电所
Dim msj As Integer
Dim rowCon As Integer
Dim l_Sql As String
Dim l_Flag As Integer
Dim DLCursor As New ADODB.Recordset

l_Sql = "select * from [day" + m_Day + "$]"
DLCursor.Open l_Sql, l_AdoConn, adOpenKeyset, adLockOptimistic

rowCon = mb

If Not DLCursor.EOF Then
DLCursor.MoveFirst
Else
Call FCloseRdt(DLCursor)
Exit Sub
End If
msj = 1
Do While Not DLCursor.EOF
If msj < 25 Then
If CStr(DLCursor.Fields(mb + 1).Value) = Null Then
l_Flag = MsgBox(MSF.TextMatrix(0, rowCon) + MSF.TextMatrix(msj, 0) + _
"的电量可能为空,是否继续导入数据?", vbYesNo)
If l_Flag = 6 Then
MSF.TextMatrix(msj, rowCon) = CInt(DLCursor.Fields(mb + 1).Va

cstr把()里面的内容转变为string类型,你判断是不是空就用空字串""就行了,给你2个方法解决:

1,判断字串是否为空
If cstr(...) = "" Then
'你的代码

2,判断字串长度是否为0
If len(cstr(...)) = 0 Then
'你的代码

If CStr(DLCursor.Fields(mb + 1).Value) = Null Then
VB似乎没有Null关键字,好像有 vbNull 和 vbNullString