Our Training Programs

All contents are copyright of their authors.

Incorrect syntax near the keyword 'WHERE'.

Incorrect syntax near the keyword 'WHERE'.

Violeta Popa

13yAsked Apr 13, 2013, 2:30 PM3.2kVisual Basic .NET

Hi :) I have this code:

string insertNrContract = "INSERT INTO client (nr_contract) VALUES ('"

+ nr_contract + "') WHERE id_client='" + id_client + "'";

and i get the error:
Incorrect syntax near the keyword 'WHERE'. I don't get what's missing. Any help? thanks

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

It is the same account you read, post and publish with — and you will come straight back to this page.

Satyapriya Nayak13y ago
Accepted answer
string insertNrContract = "INSERT INTO client (nr_contract) VALUES ('" + nr_contract.text + "') ";

use for update

string updateNrContract = "UPDATE client SET nr_contract='" + nr_contract.text + "' WHERE id_client='" + id_client .text+ "'";
Violeta Popa13y ago
ok, I understood, thank you all!
Ravi Shekhar13y ago
Where clause not works with insert statement. It works with update statement.
sandeep Tomar13y ago
hello sir use update query if you are updating data

because where clause can not be use with insert , INSERT query simply insert a new row so please use update query

string insertNrContract = "UPDATE client SET nr_contract='" + nr_contract + "' WHERE id_client='" + id_client + "'";