maybe you can execute a raw sql command "insert or ignore into TABLE..."
2012/9/15 Ibrahim Sada <[email protected]> > 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 <[email protected]> wrote: > >> okey dear thanx very much >> >> >> On 13 September 2012 17:35, Rocky <[email protected]> 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 >>> <[email protected]>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 <[email protected]> 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 <[email protected] >>>>> > wrote: >>>>> >>>>>> How to query dear....i want to know i have tried alot... >>>>>> thnx dear.. >>>>>> >>>>>> >>>>>> On 13 September 2012 12:59, Rocky <[email protected]> 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 < >>>>>>> [email protected]> 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 >>>>>>>> [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 >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> 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 >>>>>>> [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 >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> 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 >>>>> [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 >>>> >>> >>> >>> >>> -- >>> 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 [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 > -- 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
