SQLiteException while inserting data into database

Question

Android 2.3.3

static String name = "Database";
static int version = 1;

SQLiteDatabase sqlDB;
Cursor c;


public Database(Context context) {
    super(context, name, null, version);
    // TODO Auto-generated constructor stub

    sqlDB = getWritableDatabase();

    }

    @Override
    public void onCreate(SQLiteDatabase sqlDB) {
        // TODO Auto-generated method stub


    sqlDB.execSQL("create table if not exists Operations(Command Text, Pos1 Text, " +
                "Pos2 Text, Pos3 Text, Pos4 Text, Pos5 Text, Pos6 Text, Pos7 Text, Pos8 Text, Pos9 Text, Pos10 Text)");


    }

public void insertData() {
        // TODO Auto-generated method stub

        String addQuery ="ADD, add, and, had, ad, anddd, anndd, null, null, null, null";

                sqlDB.execSQL("insert into Operations values("+ addQuery +")"); 
                     //Exception at the above line
}

There are a total of 11 columns.

Can i insert NULL into the database? If yes, is there any problem with the way i am trying to insert the data into the database?

Here is the error that i am getting :::

12-21 14:53:29.629: E/AndroidRuntime(11894): Caused by: android.database.sqlite.SQLiteException: near "ADD": syntax error: insert into Operations values(ADD, add, and, had, ad, anddd, anndd, null, null, null, null)
12-21 14:53:29.629: E/AndroidRuntime(11894):    at android.database.sqlite.SQLiteDatabase.native_execSQL(Native Method)
12-21 14:53:29.629: E/AndroidRuntime(11894):    at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1765)
12-21 14:53:29.629: E/AndroidRuntime(11894):    at com.x.x.Database.insertData(Database.java:71)
12-21 14:53:29.629: E/AndroidRuntime(11894):    at com.x.x.xxx.onCreate(xxx.java:109)
12-21 14:53:29.629: E/AndroidRuntime(11894):    at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
12-21 14:53:29.629: E/AndroidRuntime(11894):    at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1615)
12-21 14:53:29.629: E/AndroidRuntime(11894):    ... 11 more

can someone help me why i am getting this error with the syntax?

Nermeen · Accepted Answer · 2012-12-21 09:38:25Z

1

Strings should be inclused in '' so change String addQuery ="ADD, add, and, had, ad, anddd, anndd, null, null, null, null";

to:

String addQuery ="'ADD', 'add', 'and', 'had', 'ad', 'anddd', 'anndd', null, null, null, null";

answered Dec 21, 2012 at 9:38

Nermeen

16k5 gold badges62 silver badges73 bronze badges

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

Comments

ray.kc.liu · Accepted Answer · 2012-12-21 09:37:59Z

0

SQL syntax error, please use insert into test(aa,bb) values('ADD','BB') which aa is your field name and 'ADD' is string

answered Dec 21, 2012 at 9:37

ray.kc.liu

4310 bronze badges

Comments

Rohit · Accepted Answer · 2012-12-21 09:43:56Z

0

According to me as you have defined a string (addQuery) with 11 value but it is counting it as a one. I'm sure there is a problem that's why you are getting runtime error.

answered Dec 21, 2012 at 9:43

Rohit

4903 silver badges15 bronze badges

1 Comment

Vamsi Challa Over a year ago

Yeah, It took the entire assignment as a string. Got it solved.

sravan · Accepted Answer · 2012-12-21 09:59:27Z

0

 //  Possible to Get Error 
    public void insertData() {
            // TODO Auto-generated method stub

            String addQuery ="ADD, add, and, had, ad, anddd, anndd, null, null, null, null";

                    sqlDB.execSQL("insert into Operations values("+ addQuery +")"); 
                         //Exception at the above line
    }

    use Like Below 

    public void insertData() {

    ContentValues cv=new ContentValues();
    cv.put("column1,value);
    cv.put("column2,value);
    cv.put("column3,value);
    cv.put("column4,value);
    cv.put("column5,value);
    cv.put("column7,value);
     database.insert(tabName, SINGLE_colName, cv);

    }

answered Dec 21, 2012 at 9:59

sravan

5,3311 gold badge33 silver badges33 bronze badges

Collectives™ on Stack Overflow

SQLiteException while inserting data into database

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related