为了评估索引属性,该属性必须是合格的并且参数必须由用户显式提供.-另一种情况
问题描述:
你好,萨拉姆....我已经尝试了所有已经讨论过的内容...但就我而言,我不知道为什么会发生与以前相同的问题...这是我的代码:
Hello,Salam....I have try everything that has been discuss... but in my case i do not know why the same problem as previous happen... here are my code:
Private Sub parsesave(ByVal paragid As String, ByVal sentenceid As String, ByVal ids As String, ByVal joinTexts As String, ByVal idv As String, ByVal kataverbjoint As String, ByVal ido As String, ByVal jointtextobj As String)
Dim dbSVO As OleDb.OleDbDataAdapter
Dim dsSVO As New DataSet
Dim parseNewRow As DataRow
dbSVO = New OleDb.OleDbDataAdapter("elect * from tableSVO", conntoMalayARM)
dsSVO = New DataSet()
dbSVO.Fill(dsSVO, "parse")
Dim commanparse As New OleDb.OleDbCommandBuilder(dbSVO)
parseNewRow = dsSVO.Tables("parse").NewRow()
parseNewRow.Item(0) = CStr(paragid)
parseNewRow.Item(1) = CStr(sentenceid)
parseNewRow.Item(2) = CStr(ids)
If joinTexts <>"" Then
parseNewRow.Item(3) = CStr(joinTexts)
Else
parseNewRow.Item(3) = "null"
End If
parseNewRow.Item(4) = CStr(idv)
If kataverbjoint <>"" Then
parseNewRow.Item(5) = CStr(kataverbjoint)
Else
parseNewRow.Item(5) = "null"
End If
parseNewRow.Item(6) = CStr(ido)
If jointtextobj <>"" Then
parseNewRow.Item(7) = CStr(jointtextobj)
Else
parseNewRow.Item(7) = "null"
End If
dsSVO.Tables("parse").Rows.Add(parseNewRow)
dbSVO.Update(dsSVO, "parse")
dbSVO.Dispose()
End Sub
请帮助我任何人....请....
[edit]已添加代码块-OriginalGriff [/edit]
Please do help me anyone.... please....
[edit]Code block added - OriginalGriff[/edit]
答
好吧,我不知道您的先前的问题"是什么,也不知道您当前的问题是什么问题是,但是经过一秒钟的检查,我的SQL语句出现了一个明显的问题.看看您是否知道这是什么:
Well, I have no idea what your "previous problem" was, nor do you say what your current problem is, but after a 1 second look at your code I can see one glaring problem with your SQL statement. See if you figure out what that is:
dbSVO = New OleDb.OleDbDataAdapter("elect * from tableSVO", conntoMalayARM)
经过更深入的检查后,我有一个问题.该代码应该执行什么操作???将字符串"NULL"放到表的列中不会使该条目成为真正的空值,那又是什么意思?
After a slightly deeper examination, I have a question. What the hell is this code supposed to be doing??? Putting the string "NULL" into the columns of a table does not make that entry a real null value, so what''s the point there?