Syntax error, unable to key email into SQLite

Question

just like the title goes, I'm unable to key the email address into SQLite databases. The error is as followed:

02-01 09:49:52.300: I/SqliteDatabaseCpp(16157): sqlite returned: error code = 1, msg = near "@gmail": syntax error, db=/data/data/com.proj.db/databases/FormDetails

There is nothing wrong in the creating of database it's only recently that I add into the email column then this error comes out. Is it because the "@" sign cannot be keyed into the database?

My code for the table:

String insertNewFormDetails = "create table if not exists " + TABLE_NAME + " ( " + BaseColumns._ID + " integer primary key autoincrement, " 
                                                            + NAME + " text not null, "
                                                            + SCHOOL + " text not null, "
                                                            + CURRENTDATE + " text not null, "
                                                            + FORMTYPE + " text not null, "
                                                            + EMAIL + " text not null);";

    db.execSQL(insertNewFormDetails);

What is the value of insertNewFormDetails and each of the String variables you use to build it? — Code-Apprentice
– Code-Apprentice, Commented Feb 1, 2013 at 2:06
Note that your SQL statement is trying to create a table with some column names that come from other variables. This is not the same as inserting data, like the variable name suggests. Column names cannot contain the @ character. — Code-Apprentice
– Code-Apprentice, Commented Feb 1, 2013 at 2:07

Yaqub Ahmad · Accepted Answer · 2013-10-24 09:30:43Z

2

Its not allowed to use the @ in column name like @Email but you can still use it by using square brackets arround the column name like [@email].

Valid:

[@Email]

InValid:

@Email

Please note that you need to reference this column like [@Email] in SQL queries and it will work.

edited Oct 24, 2013 at 9:30

answered Feb 1, 2013 at 4:41

Yaqub Ahmad

27.7k24 gold badges105 silver badges151 bronze badges

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

Collectives™ on Stack Overflow

Syntax error, unable to key email into SQLite

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