sql syntax error in vb.net

Question

I've the following vb.net function which have a syntax error in the sql commandtext that i can't seem to figure out

Private Sub addsupporderidsinbookedtoinprocess()
        Try
            Dim cnn3 As New SqlConnection(connetionString)
            Dim sqlcmd3 As New SqlCommand("SELECT supporderidinprocess FROM ordersinprocess", cnn3)
            sqlcmd3.CommandText = "INSERT INTO ordersinprocess(supporderidinprocess) VALUES(SELECT IDENT_CURRENT('[supporder]'))"
            cnn3.Open()
            sqlcmd3.ExecuteNonQuery()
            sqlcmd3.Parameters.Clear()
            cnn3.Close()
        Catch ex As SqlException
            MsgBox(ex.Message)
        End Try
    End Sub

the error is in this part

...VALUES(SELECT IDENT_CURRENT('[supporder]'))

any idea how to fix this?

John Woo · Accepted Answer · 2012-10-17 04:13:58Z

6

There should be no VALUES keyword in INSERT INTO...SELECT statement. Try something like this,

INSERT INTO ordersinprocess(supporderidinprocess) 
SELECT IDENT_CURRENT('[supporder]')

edited Oct 17, 2012 at 4:13

answered Oct 17, 2012 at 4:05

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sql syntax error in vb.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related