Solved

Incorrect syntax near ')'. for SQL Server String

Posted on 2010-11-09
2
397 Views
Last Modified: 2012-06-21
Good Day:

I am using VS.NET 2005, VB.NET, and SQL Server.  The following syntax gives me an error that reads:
Incorrect syntax near ')'.

Dim sSQL as string
   sSQL = "INSERT INTO CodesQuick(Description, Type, ) values('" & _
                                            Me.cboType.Text & "','" & _
                                            frmQuote.cboDelivery.Text & "')"


Any Suggestions?

Thanks,
Denise
0
Comment
Question by:DeniseGoodheart
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
rogerard earned 500 total points
ID: 34096779
You have an extra comma after the word type.
0
 

Author Comment

by:DeniseGoodheart
ID: 34096918
Yes of course.

Thank you rogerard.  
0

Featured Post

The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question