I have written a database adapter to implement database functions like
query(), delete(), update(), insert()....etc. So I have been able to
insert and query just fine but deleting a specific row is not working
at all. I have tested deleting all the rows and that works fine even
though the return value is still 0 or false. I have posted my
delete() method and my table:
Again, I have confirmed insert and query but not delete and after
sending this post I'm going to try the update to see if that works.
Also, the open() call just does the DBHelper.getWritableDatabase().
I'm concerned that it is the way my table is set up but I've tried all
the sql statements in a sqlite browser and that table is just fine.
db.execSQL( "CREATE TABLE " + ECHOLIST_TABLE + " (" +
"[PHONENUMBER_ID] NVARCHAR(15) PRIMARY
KEY NOT NULL, " +
"[PHONENUMBER] NVARCHAR(15) NOT NULL);"
);
public boolean deletePhoneNumber(String phonenumber)
{
open();
db.beginTransaction();
int rowsDeleted = db.delete(ECHOLIST_TABLE, PHONENUMBER_ID +
"=" + phonenumber, null);
//int rowsDeleted = db.delete(ECHOLIST_TABLE, null, null);
db.setTransactionSuccessful();
db.endTransaction();
close();
return (rowsDeleted > 0);
}
--
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
