incorrect syntax near '('

Question

1.00/5 (1 vote)

See more:

SQL

cmd.CommandText = " UPDATE Pension_Master( ppo_no, p_name,P_cat,wshd, address, dob, state_employ, depart, type_pen,   date_retire, date_commence, rate_pension,  place_payment, m_cer, l_cer, e_cer, validfrom, validto ) SET Values ('" & TextBox1.Text & "','" & TextBox2.Text & "', '" & TextBox5.Text & "', '" & TextBox3.Text & "', '" & TextBox8.Text & "','" & ComboBox6.Text & "', '" & TextBox7.Text & "', '" & DateTimePicker5.Value & "','" & DateTimePicker6.Value & "','" & DateTimePicker2.Value & "', '" & DateTimePicker3.Value & "','" & TextBox6.Text & "','" & TextBox4.Text & "'  WHERE auto_genrate = '" & ComboBox1.Text & "'"

please help me

Posted 19-Feb-14 20:24pm

tanugarg

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maarten Kools · Answer 1 · 2014-02-19T20:26:00

Solution 1

Your brackets aren't balanced. You open the ( after SET Values ( but never close it.

Posted 19-Feb-14 20:26pm

Maarten Kools

King Fisher · Answer 2 · 2014-02-19T20:39:00

Solution 2

SQL

UPDATE EMPLOYEE
  SET (WORKDEPT, PHONENO, JOB)
      = ('D11', '7213', 'DESIGNER')
  WHERE EMPNO = '000270'

else

SQL

update MyEmployees set columnname1='value1',column2='Value2',column3='value3' where auto_genrate='Pension_Maste'

Posted 19-Feb-14 20:39pm

King Fisher

Bernhard Hiller · Answer 3 · 2014-02-19T21:13:00

There are a few issues.
1. The language is not VB but SQL.
2. The syntax of an UPDATE statement differs from the syntax of an INSERT statement.
INSERT INTO MyTable (column names) VALUES (my values)
vs.
UPDATE Mytable SET column1=value1, column2=value2 WHERE IDColumn=idvalue
3. Do not create the query by string concatenation in your VB code, prefer parameterized queries. Parameterized queries help you circumvent the SQL Injection Attack issue, and - otherwise surely one of your questions soon to follow - issues with the DateTime type.

prakashdotnet · Answer 4 · 2014-02-19T21:21:00

Solution 4

use following syntax

SQL

Update table1 
 set col2 = "xyz"
,col3 = "pqr"
WHERE col1 = "abc"

Posted 19-Feb-14 21:21pm

prakashdotnet

Comments

Member 13607118 16-Jan-18 6:10am

incorrect syntax near 'abc', in vb.net

This is my full code to read the data from database

Imports System.Data.SqlClient
Public Class Form3

Dim con As New SqlConnection
Dim cmd As New SqlCommand

Private Sub Form3_Load(sender As Object, e As EventArgs) Handles MyBase.Load
con.ConnectionString = "Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\vikash\booking1\booking1\Database1.mdf;Integrated Security=True"
con.Open()
cmd.Connection = con
cmd.CommandText = "select id from details1"
Dim dr1 As SqlDataReader
dr1 = cmd.ExecuteReader
Do While dr1.Read
ComboBox1.Items.Add(dr1("id"))
Loop
dr1.Close()

End Sub

Private Sub ComboBox1_SelectedIndexChanged(sender As Object, e As EventArgs) Handles ComboBox1.SelectedIndexChanged
Dim dr2 As SqlDataReader
Dim cmd2 As New SqlCommand
cmd2.Connection = con
cmd2.CommandText = "select Receivername,Receiveremail,Receivercity,Receiverpincode,Receivermobile,Sendername,Senderemail,Sendercity,Senderpincode,Sendermobile from details1 WHERE id=" & ComboBox1.Text & ""
Dim parameterstate As New SqlParameter("@id", SqlDbType.VarChar)
parameterstate.Direction = ParameterDirection.Input
parameterstate.Value = ComboBox1.SelectedIndex
cmd2.Parameters.Add(parameterstate)
dr2 = cmd2.ExecuteReader

Do While dr2.Read

TextBox1.Text = dr2("Receivername")
TextBox2.Text = dr2("Receiveremail")
TextBox3.Text = dr2("Receivercity")
TextBox4.Text = dr2("Receiverpincode")
TextBox5.Text = dr2("Receivermobile")
TextBox6.Text = dr2("Sendername")
TextBox7.Text = dr2("Senderemail")
TextBox8.Text = dr2("Sendercity")
TextBox9.Text = dr2("Senderpincode")
TextBox10.Text = dr2("Sendermobile")

Loop
dr2.Close()

End Sub

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Form4.Show()

End Sub
End Class

Please help out quickly