I created a database using SQLiteOpenHelper and I'm trying to query
it. It returns the cursor but when I call moveToFirst() it crashes
with the error SQL Logic Error or Missing Database.
My code for the database:
public class Database{
private static final String DATABASE_NAME = "MyDatabase";
private static final int DATABASE_VERSION = 1;
private static final String TABLE_NAME = "MyTable";
// Column Names
public static final String ID = "_id";
// INTEGER
public static final String NUMBER = "number";
// TEXT
private SQLiteDatabase database;
private DatabaseHelper mDatabaseOpenHelper;
public Database(Context context){
mDatabaseOpenHelper = new DatabaseHelper(context);
database = mDatabaseOpenHelper.getWritableDatabase();
}
public void close(){
database.close();
}
public long addNumber(String number){
ContentValues values = new ContentValues();
values.put(NUMBER, number);
return database.insert(TABLE_NAME, null, values);
}
public Cursor getTrUpdate(String number){
String selection = NUMBER + " MATCH ?";
String[] selectionArgs = new String[] {number};
return database.query(TABLE_NAME, null, selection,
selectionArgs,
null, null, null);
}
private class DatabaseHelper extends SQLiteOpenHelper{
private static final String CREATE_TABLE = "CREATE TABLE " +
TABLE_NAME +
"(_id INTEGER PRIMARY KEY AUTOINCREMENT, " +
NUMBER + " TEXT)";
public DatabaseHelper(Context context){
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(CREATE_TABLE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int
newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
onCreate(db);
}
}
}
And how I query:
Database database = new Database(this);
Cursor cursor = database.getTrUpdate("1234");
if (cursor.moveToFirst()){
do{
int d = cursor.getInt(cursor.getColumnIndex(Database.ID));
} while(cursor.moveToNext());
}
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
