I am trying to update a SQLite database table with values selected from comboboxes in VB.Net.
The first part of the query works, but if I include a where statement I get the following error : 'SQL logic error
near "Where": syntax error'
I have tried .selected text, but the error persists. What am I missing ?
Code:Dim opdragKopersWatBotteleer As New SQLiteCommand opdragKopersWatBotteleer.Connection = konneksie opdragKopersWatBotteleer.CommandText = " Update Verkope " & "set Gebottel = ( '" & BottelComboBox.SelectedItem & " ' " & "Where verkope.DebiteurNaam = '" & KoperComboBox.SelectedItem & "' )" opdragKopersWatBotteleer.ExecuteNonQuery()
Regards




Reply With Quote
