lothos12345 Posted October 10, 2003 Posted October 10, 2003 I am getting an error on the ExecuteNonQuery part of my VB.NET program and I am unsure why. Any help given would be greatly appreciated. Below is an example of my code: DataSet11.Clear() Dim intnumber As Integer intnumber = CInt(fldmainid.Text) Call Connection() objAdapter.UpdateCommand = New OleDb.OleDbCommand() objAdapter.UpdateCommand.Connection = objConnection objAdapter.UpdateCommand.CommandText = "UPDATE * Daily WHERE Daily.mainid =" & intnumber objAdapter.UpdateCommand.ExecuteNonQuery() <-- Error objAdapter.Update(DataSet11, "Daily") objConnection.Close() Quote
Moderators Robby Posted October 10, 2003 Moderators Posted October 10, 2003 the Update should be written like this.... "UPDATE Daily SET SomeColumn = SomeValue WHERE mainid =" & intnumber Quote Visit...Bassic Software
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.