If(! data_available_in_DB) { then insert data into db }
Bro i didnt get ur query.. Can u help me out for this.... Thanx.... On 13 September 2012 17:52, Ibrahim Sada <ibrahim.in...@gmail.com> wrote: > okey dear thanx very much > > > On 13 September 2012 17:35, Rocky <rkjhaw1...@gmail.com> wrote: > >> 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 >> > > -- 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