Use adb logcat, DDMS, or the DDMS perspective in Eclipse to examine
LogCat and look at your stack trace associated with your error.
In your case, you will find that you have invalid SQL, because your
string is not quoted. Please use:
String[] args={string};
myDB.execSQL("DELETE FROM tablename where colname=?", args);
On Mon, Feb 14, 2011 at 9:15 AM, Abhilash baddam
<[email protected]> wrote:
> Hi,
> In sqlite database, i am having some values. How can i delete a
> particular value from database. I tried like but showing error..
> What mistake is i am doin here..?
> myDB.execSQL("DELETE FROM tablename where colname="+string);
> i want to delete the value at that particulat string.
> Any help regarding this issue?
>
> --
> 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
--
Mark Murphy (a Commons Guy)
http://commonsware.com | http://github.com/commonsguy
http://commonsware.com/blog | http://twitter.com/commonsguy
Warescription: Three Android Books, Plus Updates, One Low Price!
--
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
