Incorrect syntax near ')'. Error
Posted on 2008-06-18
I am using WinForms VB.NET 2005 with SQL Server 2000. I get an error that reads Incorrect syntax near ')'. for the following code:
sSQL = "INSERT INTO NodeChild_t(ID, Child,UserGroup,) values('" & _
Me.cboParent.SelectedValue & "','" & _
Me.cboChild.Text & "','" & _
Me.cboGroup.Text & "')"
I always get confused when I have to concatenate an sql string. Any suggestions?