How Do I Update A Sqlite Row Entry By String?

I am a noob to android and I am trying to update a sqlite row entry by string as opposed to row number. I have no problems creating an entry and then deleting an entry by string.

Solution 1:

From your logcat, it seems you forgot to close the cursor or database somewhere. Please can you post the code where you are calling these methods.

Solution 2:

Do you have a stack trace that can show more information about the error? You can get one using the Eclipse debugger or through adb logcat. It might show you what variable is null.

If you are getting a NullPointerException, probably one of your arguments to ourDatabase.update is null when it shouldn't be. Throws in some asserts to check your assumptions (or just use the debugger, it will probably show the problem).