I use SQL server 2000 for my database, and for conection i use ADO
but i get error when i want to save data? like this
"Key column information is insufficent or incorrect. Too many rows were affected by update. "
this my code
Private Sub Command8_Click()
If add = True Then
rs.AddNew
Else
rs.UpdateBatch
End If
save_data
rs.Update
rs.MoveFirst
DataGrid1.Refresh
Call load_form
first_button
colour_save_text
lock_text
End Sub
maybe someone can help me?
thanks
but i get error when i want to save data? like this
"Key column information is insufficent or incorrect. Too many rows were affected by update. "
this my code
Private Sub Command8_Click()
If add = True Then
rs.AddNew
Else
rs.UpdateBatch
End If
save_data
rs.Update
rs.MoveFirst
DataGrid1.Refresh
Call load_form
first_button
colour_save_text
lock_text
End Sub
maybe someone can help me?
thanks