android database exception

Question

I am trying to create a database on android and when I run an exception is raised:

Database - Failure 1 (near "integer" : syntax error) on 0x1ac028 when preparing 'create table list1 (id integer Primary key autoincrement, task text not null, check integer not null)'

I don't understand why this is happening. This is my code:

String dbName="projectDatabase";
    String tableName="List1";
    String TableStructure="create table " + tableName +" (id integer Primary key autoincrement, task text not null, check integer not null)";
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        Button cb = (Button) findViewById(R.id.creatbutton);
        cb.setOnClickListener(new OnClickListener() {

            @Override
            public void onClick(View arg0) {
                // TODO Auto-generated method stub
                try{
                    SQLiteDatabase ldb = openOrCreateDatabase(dbName, Context.MODE_PRIVATE, null);
                    ldb.execSQL(TableStructure);}catch(Exception e){
                        Toast.makeText(DsTest2Activity.this, "Failed", Toast.LENGTH_LONG).show();
                    }
                Intent list = new Intent(DsTest2Activity.this,List.class);
                startActivity(list);
            }
        });
    }

i think its check id not null in the create statement. Once check it — G_S
– G_S, Commented Nov 21, 2012 at 17:13

Barak · Accepted Answer · 2012-11-21 17:17:18Z

3

check is an SQLite keyword. You cannot use it as a table or column name.

Change your column name to something else and your error will go away.

String TableStructure="create table " + tableName +" (id integer Primary key autoincrement, task text not null, checknum integer not null)";

For a complete list of curent SQLite keywords, look here.

answered Nov 21, 2012 at 17:17

Barak

16.4k9 gold badges54 silver badges86 bronze badges

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

Comments

CL. · Accepted Answer · 2012-11-21 17:44:51Z

1

To use a keyword directly as a column name, quote it:

..., "check" integer not null)

answered Nov 21, 2012 at 17:44

CL.

182k18 gold badges241 silver badges282 bronze badges

1 Comment

Barak Over a year ago

+1 True, but then you have to escape the quote marks (to use in the method that the OP is using it). Simpler to just change the column name IMO. :p

Rodolfo Faquin · Accepted Answer · 2012-11-21 17:32:19Z

-1

Good afternoon, put into your code _id integer primary key autoincrement, ..., for exemple:

CREATE TABLE tabela(_id integer primary key autoincrement, task text not null, check integer not null);

answered Nov 21, 2012 at 17:32

Rodolfo Faquin

8201 gold badge8 silver badges15 bronze badges

1 Comment

Barak Over a year ago

check is an SQLite keyword... it cannot be used as a table or column name.

Collectives™ on Stack Overflow

android database exception

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related