exactly.. :) Then before insertion system will erase all info from db, u wouldn't get any kinds of repetition of data.
OR check if data is available into db If(! data_available_in_DB) { then insert data into db } this is second way to handl.e On Thu, Sep 13, 2012 at 5:28 PM, Ibrahim Sada <ibrahim.in...@gmail.com>wrote: > u mean i have to call this method before inserting? > > public boolean deleteRecord(long rowId) { > return db.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId, > null) > 0; > } > > thnx dear.. > > > On 13 September 2012 17:24, Rocky <rkjhaw1...@gmail.com> wrote: > >> delete query of that table. >> >> u need to delete all data of that table before inserting. >> >> >> On Thu, Sep 13, 2012 at 1:00 PM, Ibrahim Sada <ibrahim.in...@gmail.com>wrote: >> >>> How to query dear....i want to know i have tried alot... >>> thnx dear.. >>> >>> >>> On 13 September 2012 12:59, Rocky <rkjhaw1...@gmail.com> wrote: >>> >>>> when u will run apps, that many time it will insert into database, two >>>> solution - >>>> >>>> 1. after first time insert, comment this insert statement >>>> 2. before insert, write delete query for the same table. >>>> >>>> >>>> >>>> >>>> On Thu, Sep 13, 2012 at 12:55 PM, Ibrahim Sada <ibrahim.in...@gmail.com >>>> > wrote: >>>> >>>>> Hello friends... >>>>> i am inserting values in databse sqlite table from the code... >>>>> But when ever i run the code or programe itse inserting value >>>>> again >>>>> >>>>> >>>>> Assume i have 1,2,3,4,5 and i run the code then its inserting >>>>> >>>>> 1,2,3,4,5 >>>>> >>>>> and when i run the code again its comming twice... >>>>> that is >>>>> 1,2,3,4,5 >>>>> 1,2,3,4,5 >>>>> >>>>> can any one help me... >>>>> Thanx in advance,,, >>>>> >>>>> -- >>>>> 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 >>>> >>>> >>>> >>>> >>>> -- >>>> Thanks & Regards >>>> >>>> Rakesh Kumar Jha >>>> Android Developer, Trainer and Mentor >>>> Bangalore >>>> Skype - rkjhaw >>>> (O) +918050753516 >>>> (R) +919886336619 >>>> >>>> -- >>>> 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 >>> >>> >>> -- >>> 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 >>> >> >> >> >> -- >> Thanks & Regards >> >> Rakesh Kumar Jha >> Android Developer, Trainer and Mentor >> Bangalore >> Skype - rkjhaw >> (O) +918050753516 >> (R) +919886336619 >> >> -- >> 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 >> > > -- > 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 > -- Thanks & Regards Rakesh Kumar Jha Android Developer, Trainer and Mentor Bangalore Skype - rkjhaw (O) +918050753516 (R) +919886336619 -- 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