Solved

Incorrect syntax near ')'. for SQL Server String

Posted on 2010-11-09
2
388 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
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now