Syntaxerror missing operator in query expression SN='. Invb6

Question

con.Open Constr rs.Open  Select NamePhonenoAge from Test where SN = & addEdit.Text con For a = 1 To ListView1.ListItems.Count If ListView1.ListItems.Item(a).Checked = True Then addEdit.Text = rs(  SN ) sql =  delete from Test where SN= & addEdit.Text addEdit.Text =  SN NameText.Text =   PhText.Text =   AgeText.Text =   NameText.SetFocus con.Execute (sql) End If rs.MoveNext Next con.Close

Nitin Sontakke · Answer

Further to what Amit has said change as follows: from:  Select NamePhonenoAge from Test where SN = & addEdit.Text to:  Select NamePhonenoAge from Test where SN = ' & addEdit.Text & ' and from: sql =  delete from Test where SN= & addEdit.Text to: sql =  delete from Test where SN = ' & addEdit.Text & ' All credit to Amit please.

Amit Gupta · Answer

I don't know much about vb.net. var query = delete from test where sn = 'xyz'; Single quote is missing

Jitendra Shekhawat · Answer

Thanks Amit Sir & Nitin Sir