Android - SQLite create table error

Question

The error says something like (near "create": syntax error) when preparing 'create table option... create table score... I'll just post all other codes in my program so that I can ask whenever there's more problem encountered.

This is my table (in DBHelper.java):

final static String sqlcreate=

        "create table option (id integer primary key autoincrement," + 
        "volume boolean not null, vibrate boolean not null, theme text not null) " +    

        "create table score (id integer primary key autoincrement," +
        "score text not null, difficulty text not null, date date not null, );";

This is my DBFunction.java:

public int addScore(String score, String difficulty){

ContentValues values = new ContentValues();

    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); 
    Date scoredate = new Date();    
    values.put("score", score);
    values.put("difficulty", difficulty);
    values.put("date", dateFormat.format(scoredate));   
    return (int) db.insert(tableScore, null, values);
}`

And this is my OnClick():

if (v==btnadd){

        String vol = tbtnvol.getText().toString();
        String vib = tbtnvib.getText().toString();
        String theme = themename.getText().toString();
        options.open();
        options.addOption(vol, vib, theme);
        options.close();
        Toast.makeText(this, "Data has been added", Toast.LENGTH_LONG).show();
    }`

waqaslam · Accepted Answer · 2012-04-06 17:59:57Z

1

Fix your query as below:

"create table option (id integer primary key autoincrement," + 
"volume boolean not null, vibrate boolean not null, theme text not null); " +

"create table score (id integer primary key autoincrement," +
"score text not null, difficulty text not null, date date not null);";

You have missed semi-colon and left an extra comma in your query

answered Apr 6, 2012 at 17:59

waqaslam

68.3k17 gold badges172 silver badges180 bronze badges

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

1 Comment

Harambe Attack Helicopter Over a year ago

Oh, it is not included in my query, sorry.. It's suppose to be "`", the one that you type here in stackoverflow when writing codes.. I'll just fix that.. I'll try first to separate my table into different variables.

Graham Perks · Accepted Answer · 2012-04-06 17:58:24Z

0

You need to separate the two SQL statements in there with a semicolon.

... theme text not null); " +   <-- semi colon added here
"create table score ...

answered Apr 6, 2012 at 17:58

Graham Perks

23.5k8 gold badges65 silver badges84 bronze badges

Comments

MAC · Accepted Answer · 2012-04-06 18:00:46Z

0

your first Query without error

create table option (id integer primary key autoincrement,volume boolean not null, vibrate boolean not null, theme text not null)

second query

create table score (id integer primary key autoincrement," +

"score text not null, difficulty text not null, date date not null)

i have checked it now it works fine

answered Apr 6, 2012 at 18:00

MAC

15.9k8 gold badges57 silver badges96 bronze badges

Comments

Chintan Raghwani · Accepted Answer · 2012-04-06 18:01:02Z

0

remove , from end

"create table score (id integer primary key autoincrement," +
    "score text not null, difficulty text not null, date date not null, );";

write as follow

"create table score (id integer primary key autoincrement," +
    "score text not null, difficulty text not null, date date not null);";

yup, and also put ; at end as Graham said

answered Apr 6, 2012 at 18:01

Chintan Raghwani

3,3704 gold badges24 silver badges33 bronze badges

Collectives™ on Stack Overflow

Android - SQLite create table error

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related