Insert into SQLite

Question

I am trying to insert text messages from an inbox to a SQLite Database, but due to some special characters/symbols it doesn't insert properly.

I went through some question in Stackoverflow but nothing seems useful.

I got this code, but it is not working.

data.execSQL("INSERT INTO recor(text) VALUES('"+DatabaseUtils.sqlEscapeString(messag)+"')");

My database has only one field in it and am trying to insert details of messages along with it. I am putting the details (type, time, number, message) to a single string message and recor is my table name.

This is what I get as toast when I use a try catch loop.

Error is near:

"FROM":syntax error:INSERT INTO recor(text) VALUES("FROM 15555215556 Message:-MSG")

maybe it is just a typo and you mean record instead of recor ? — Patrick Oscity
– Patrick Oscity, Commented Jul 8, 2012 at 18:18

azgolfer · Accepted Answer · 2012-07-08 18:22:13Z

2

Uses the DatabaseAdapter's insert method instead. e.g.

ContentValues values = new ContentValues(); values.put(COLUMN_NAME, value); dbAdapter.insert(TABLE_NAME, null, values);

it looks like your column name is 'text'? this must be wrong, as text is a keyword in sqlite.

answered Jul 8, 2012 at 18:22

azgolfer

15.1k4 gold badges51 silver badges46 bronze badges

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

2 Comments

Patrick Oscity Over a year ago

i can't imagine that text can't be a column name in sqlite

suja Over a year ago

yup me too @padde... i dont think text does much problem here... problem is when some symbols come it doesn't get inserted..

Ian Newson · Accepted Answer · 2012-07-08 18:54:16Z

Your final SQL string seems to include two sets of quotes around the string you are inserting, so I assume the DatabaseUtils.sqlEscapeString method adds its own quotes around the string.

Therefore, your code should be:

data.execSQL("INSERT INTO recor(text) VALUES("+DatabaseUtils.sqlEscapeString(messag)+")");

Collectives™ on Stack Overflow

Insert into SQLite

2 Answers 2

2 Comments

Comments

Hot Network Questions