SQLiteException with android

Question

String insertQuery= "INSERT INTO"+ Table_Name +"(Coloum1, Coloum2, Coloum3, Coloum4,Coloum5,Coloum6,Coloum7,Coloum8,Coloum9) VALUES('fname','lname','dob','address','pin','city','tel','eid','date')" ;       
sd.execSQL(insertQuery);

I want to write in sqlite db throu this code but it throws an exception:

08-24 09:51:53.858: E/(595): Exception   android.database.sqlite.SQLiteException: near "INTORegistrationTable11": syntax error: , while compiling: INSERT INTORegistrationTable11(Coloum1, Coloum2, Coloum3, Coloum4,Coloum5,Coloum6,Coloum7,Coloum8,Coloum9) VALUES('fname','lname','dob','address','pin','city','tel','eid','date')

Jon Skeet · Accepted Answer · 2012-08-24 06:20:19Z

1

Look at the SQL it's complaining about "INTORegistrationTable11"

See the lack of a space?

This:

String insertQuery= "INSERT INTO" + Table_Name + "(Coloum1, ...

should be:

String insertQuery = "INSERT INTO " + Table_Name + " (Coloum1, ...

Reading error messages carefully is an important part of software engineering.

answered Aug 24, 2012 at 6:20

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

Comments

agou · Accepted Answer · 2012-08-24 06:21:13Z

0

String insertQuery= "INSERT INTO "+ Table_Name +" (Coloum1, Coloum2, Coloum3, Coloum4,Coloum5,Coloum6,Coloum7,Coloum8,Coloum9) VALUES('fname','lname','dob','address','pin','city','tel','eid','date')" ;

Add a space after INTO.

answered Aug 24, 2012 at 6:21

agou

7381 gold badge10 silver badges24 bronze badges

Comments

s.d · Accepted Answer · 2012-08-24 07:10:09Z

0

Spaces, be very careful when composing such strings for SQL, always make sure there is proper space before and after each SQL symbol and word. Also, why not use the built in insert() function and provide your data through ContentValues ?

answered Aug 24, 2012 at 7:10

s.d

29.4k3 gold badges82 silver badges133 bronze badges

Collectives™ on Stack Overflow

SQLiteException with android

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related