Loading

Syntaxerror missing operator in query expression SN='. Invb6

Jitendra Shekhawat

 con.Open Constr    
  rs.Open "Select Name,Phoneno,Age 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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago

Accepted answer

Further to what Amit has said, change as follows:

from:

"Select Name,Phoneno,Age from Test where  SN  =" & addEdit.Text

to:

"Select Name,Phoneno,Age 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.

Jitendra Shekhawat9y ago
Thanks Amit Sir
& Nitin Sir
Amit Gupta9y ago
I don't know much about vb.net.

var query = "delete from test where sn = 'xyz'";

Single quote is missing