I'm having an issue where this SQL statement isn't updating anything.
testNum returns "0" saying it affected no rows.Code:Using conn As New OleDbConnection(My.Settings.dcConn) Using update As New OleDbCommand("UPDATE events SET title = @title WHERE event_id = @event_id", conn) update.Parameters.AddWithValue("@event_id", ep.event_id) update.Parameters.AddWithValue("@title", txtTitle.Text) conn.Open() Dim testNum As Integer testNum = update.ExecuteNonQuery() MessageBox.Show(testNum) End Using End Using
I get no errors with the Statement itself.
Other queries on the DB are working fine.
event_id is an Integer and is being populated with a valid ID.
Does anyone have any ideas why this might not be working?
Maybe you see something I'm doing wrong?




Reply With Quote