Hi,
what type of mistake is i am doing?
On Mon, Feb 14, 2011 at 8:11 PM, Abhilash baddam <
[email protected]> wrote:
> Hi,
>
> In my code i used the command like this,* *
> *
> *
> * myDB.execSQL("DELETE FROM tablename where colname="+string,null);*
>
> In the place of args i am passing null, is it correct what exactly i have
> to pass there.
>
>
> On Mon, Feb 14, 2011 at 8:06 PM, Abhilash baddam <
> [email protected]> wrote:
>
>> Hi,
>>
>> i am getting that string, dynamically.
>>
>>
>> On Mon, Feb 14, 2011 at 7:54 PM, Mark Murphy <[email protected]>wrote:
>>
>>> 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
>>>
>>
>>
>
--
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
