Satish.digit
Member
Hi,
I am using below code to update record based on ID but i am getting Runtime error 3704 can any one help me on this.
Private Sub LblAllot_Click()
Dim counter As Integer, cn As New ADODB.Connection, ssql14 As String
counter = 0
DB_Open_Connection
For i = 0 To lstClaimLineList.ListCount - 1
If lstClaimLineList.Selected(i - counter) Then
ssql14 = ("update Table1 set [Name] = 'agandhi' where ID = 2")
cn.Execute ssql14
End If
Next i
DB_Close_Connection
End Sub
I am using below code to update record based on ID but i am getting Runtime error 3704 can any one help me on this.
Private Sub LblAllot_Click()
Dim counter As Integer, cn As New ADODB.Connection, ssql14 As String
counter = 0
DB_Open_Connection
For i = 0 To lstClaimLineList.ListCount - 1
If lstClaimLineList.Selected(i - counter) Then
ssql14 = ("update Table1 set [Name] = 'agandhi' where ID = 2")
cn.Execute ssql14
End If
Next i
DB_Close_Connection
End Sub