Sql syntax error with INTO statement VB.net OleDB

Question

Just edited this subroutine so I can now save a value for language and font.

It worked perfectly fine before, but now it gives me a syntax error with the sql string.

    Sub insertuservalues(conn, a, b, c, d, e, f)
        Dim sql As String = "INSERT INTO tblUserDetails(Name,Username,[Password],Email,Language,Font) VALUES (@name, @username, @password, @email, @language, @font)"
        Using connection As New OleDbConnection(conn)
            Using command As New OleDbCommand(sql, connection)
                connection.Open()
                command.Parameters.Add("@name", OleDbType.VarWChar).Value = a
                command.Parameters.Add("@username", OleDbType.VarWChar).Value = b
                command.Parameters.Add("@password", OleDbType.VarWChar).Value = c
                command.Parameters.Add("@email", OleDbType.VarWChar).Value = d
                command.Parameters.Add("@language", OleDbType.VarWChar).Value = e
                command.Parameters.Add("@font", OleDbType.VarWChar).Value = f
                command.ExecuteNonQuery()
                connection.Close()
            End Using
        End Using
    End Sub

Fields Language and Font were added to the table, and all the variables passed have a valid value. Why could this be?

Kate · Accepted Answer · 2020-05-06 23:21:11Z

1

Is this SQL Server ? You should add a tag to the question for your DBMS. But since you mention the problem began after adding those two columns it is quite likely the column names are the problem.

In SQL Server Language is a reserved keyword. See the list: Reserved Keywords (Transact-SQL). Avoid reserved keywords (or overly generic keywords) when naming objects. But if you enclose the column name between brackets (like [Password]) that should work.

I would rather use names like user_language, user_password etc. (password should be a reserved keyword in Mysql).

answered May 6, 2020 at 23:21

Kate

1,8361 gold badge11 silver badges9 bronze badges

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

2 Comments

jmcilhinney Over a year ago

It's likely Access but your advice stands regardless.

Kxpr Over a year ago

It's not server, just access. But I did have a feeling language could be a keyword. All makes sense now. Thank you.

Collectives™ on Stack Overflow

Sql syntax error with INTO statement VB.net OleDB

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related