SQLite Insert error due to SQLite Command {"SQLite error\r\nnear \"Values\": syntax error"}

Question

I'm receiving this error '{"SQLite error\r\nnear \"Values\": syntax error"}'. with the following block of code.

    using (SQLiteConnection connection = new SQLiteConnection())
    {
        connection.ConnectionString = ConnectionString;
        connection.Open();
        using (SQLiteCommand insertSQL = new SQLiteCommand(connection))
        {
            insertSQL.CommandText = "INSERT INTO BetaValues(Name, Values)  VALUES(@param1, @param2)";
            //insertSQL.CommandType = CommandType.Text;
            insertSQL.Parameters.Add("@param1", DbType.String).Value = beta.Name.ToString();
            insertSQL.Parameters.Add("@param2", DbType.String).Value = beta.ValuesXML.ToString();
            insertSQL.ExecuteNonQuery();
        }

The data definition of my table is the following.

CREATE TABLE BetaValues (
    idBetaValues INTEGER     PRIMARY KEY,
    Name         STRING (20) NOT NULL
                             UNIQUE,
    [Values]     TEXT        UNIQUE
);

I've been trying to wrap my head around this error, but I can't find the reason why I'm receiving the previous error.

Values is a reserved word in SQL. You have to escape the name in your INSERT statement the same way you did in your CREATE statement. — Dour High Arch
– Dour High Arch, Commented Nov 28, 2017 at 18:51

Fruchtzwerg · Accepted Answer · 2017-11-28 19:08:18Z

3

Since VALUES is a SQL operator you need to use a delimited identifier to identify the column correctly. In SQLite you could to add square brackets [ColumnName] around the column name. Note that there are also other quotes possible. Have a look at the create query you've already written and modify your insert statement like

INSERT INTO BetaValues(Name, [Values]) VALUES(@param1, @param2)

to solve your problem.

edited Nov 28, 2017 at 19:08

answered Nov 28, 2017 at 18:52

Fruchtzwerg

11.4k12 gold badges44 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

SQLite Insert error due to SQLite Command {"SQLite error\r\nnear \"Values\": syntax error"}

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