Basic troubles with SQLite databases. Notepad tutorial of android

Question

This is a very basic question. I am just trying to understand how SQLite database works. So, here's what I do: In the code section below which is taken from notepad tutorial 3rd exercise, I change KEY_TITLE to KEY_NAME and all place I find title to name. And the application crashes. Why does this happen?

public static final String KEY_TITLE = "title";
//change to:     public static final String KEY_NAME = "name";
public static final String KEY_BODY = "body";
public static final String KEY_ROWID = "_id";

private static final String TAG = "NotesDbAdapter";
private DatabaseHelper mDbHelper;
private SQLiteDatabase mDb;

/**
 * Database creation sql statement
 */
private static final String DATABASE_CREATE =
    "create table notes (_id integer primary key autoincrement, "
    + "title text not null, body text not null);";

/*change to: private static final String DATABASE_CREATE = "create table notes (_id integer primary key autoincrement, " + "name text not null, body text not null);"; */

Are you getting any errors in the logs? Any errors from the program before it crashes? — ipd
– ipd, Commented Jul 14, 2011 at 23:08

John O'Connor · Accepted Answer · 2011-07-15 01:08:16Z

1

It would be helpful if you copied the stack trace (using logcat / DDMS) or copied your entire SQLiteDBAdapter, but just looking at what you posted, you definitely have a problem in that you're using the wrong field name in the sqlite database create statement.

The "title" field should be renamed "name" to match your changed column name.

Change:

private static final String DATABASE_CREATE =
"create table notes (_id integer primary key autoincrement, "
+ "title text not null, body text not null);";

To

private static final String DATABASE_CREATE =
"create table notes (_id integer primary key autoincrement, "
+ "name text not null, body text not null);";

I also tend to just use the statics themselves in the create statement, so it could be written like the following:

    private static final String DATABASE_CREATE =
"create table notes (" + KEY_ROWID + " integer primary key autoincrement, "
+ KEY_NAME + " text not null, " + KEY_BODY + " text not null);";

Then you could change the names often and not encounter database create breakage.

answered Jul 15, 2011 at 1:08

John O'Connor

5,2742 gold badges26 silver badges29 bronze badges

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

1 Comment

Spectre Over a year ago

This is exactly what I did. Still it crashes. I am stumped.

success_anil · Accepted Answer · 2011-07-15 01:25:58Z

0

I guess problem is .. you are using KEY_NAME = "name"... Now as far as what I can see in your code that you are not creating a table in which you have 'name' coloumn. Now again might be you are trying to access value of name column which doesn't actually der in the table so it's throwing exception. But still a look to the Logcat (if you post here) can provide better answers to the problem.

Cheers!

answered Jul 15, 2011 at 1:25

success_anil

3,6583 gold badges30 silver badges31 bronze badges

2 Comments

Spectre Over a year ago

Ok. I got the issue. I uninstalled the application from my phone and I reinstalled it. And it works now. Any ideas why this works?

success_anil Over a year ago

Probably the application has already created a table with different coloumn. So when you were accessing that table it was throwing error. When you removed and reinstalled .. it just created a new table ...with the coloums you wanted. I guess this could be the reason

Collectives™ on Stack Overflow

Basic troubles with SQLite databases. Notepad tutorial of android

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related