Hi.
I am having some trouble working with the SQLite database. I am able
to create the database, add to it, and delete from it with no problem
by following the Notepad examples, but I am trying to avoid duplicates
and therefore want to check to see if an entry exists already.
Below is the code I have for testing to see if a game exists. I get
the correct Log message of "No Games" when there are no games, as well
as the correct value for column from getColumnIndex which is proven to
me by the log printout telling me that column = 1.
The error message that I receive if I don't catch the exception says
"Caused by android.database.CursorIndexOutOfBoundsException: Index -1
requested, with a size of 1
Where is Index -1 being requested if my call to getColumnIndex is
returning 1? Thanks for any help.
public boolean haveGame(){
gamesCursor = dbHelper.fetchAllAssets();
startManagingCursor(gamesCursor);
int numGames = gamesCursor.getCount();
if (numGames > 0){
int column = gamesCursor.getColumnIndex("hunt_name");
try {
String game = gamesCursor.getString(column);
Log.i("GAMES","Game: " + game);
} catch (CursorIndexOutOfBoundsException cioob){
Log.i("GAMES","Col: "+Integer.toString(column)+" | OOB
Exception");
}
return false;
} else {
Log.i("GAMES","No Games");
return false;
}
}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
