{"id":5468,"date":"2022-08-28T21:11:00","date_gmt":"2022-08-28T15:41:00","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/"},"modified":"2022-08-28T21:11:00","modified_gmt":"2022-08-28T15:41:00","slug":"solved-delete-records-from-sqlite-in-android-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/","title":{"rendered":"[Solved] Delete records from SQLite in Android [closed]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

Since you are not going to keep any records offline after pushing to server.<\/p>\n

you can just delete all the records of the table after the successful API call.<\/p>\n

public void deleteAll(String tableName){\n\nSQLiteDatabase db = this.getWritableDatabase();\n\ndb.execSQL(\"DELETE FROM \"+tableName); \n\ndb.close();\n\n}\n<\/code><\/pre>\n
if you plan to keep records offline you can have a separate column like status<\/code> to reflect various states of the record(It depends upon the requirement)<\/p>\n
\n
Value -> Meaning<\/p>\n
A -> Added and not synced to server<\/p>\n
S -> Synced to server<\/p>\n
M -> Modified the synced record<\/p>\n
DL -> Deleted locally <\/p>\n
D -> completely deleted both in server and app.<\/p>\n<\/blockquote>\n
you can use Update<\/code> sql command for modifying status of existing column.<\/p>\n
If you plan to delete some records based on Status<\/code> value.Let’s D is completely useless.so we can go ahead like.<\/p>\n
public void deleteMarked(String tableName){\n\nSQLiteDatabase db = this.getWritableDatabase();\n\ndb.execSQL(\"DELETE FROM \"+tableName+\" where status=\"D\"\");\n\ndb.close();\n\n}\n<\/code><\/pre>\n<\/p><\/div>\n
<\/div>\n<\/div>\n
            3<\/span> <\/p><\/div>\n<\/div>\n
[ad_2]<\/p>\n
solved Delete records from SQLite in Android [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"
[ad_1] Since you are not going to keep any records offline after pushing to server. you can just delete all the records of the table after the successful API call. public void deleteAll(String tableName){ SQLiteDatabase db = this.getWritableDatabase(); db.execSQL(“DELETE FROM “+tableName); db.close(); } if you plan to keep records offline you can have a separate … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[452,707],"class_list":["post-5468","post","type-post","status-publish","format-standard","hentry","category-solved","tag-android","tag-sqlite"],"yoast_head":"\n[Solved] Delete records from SQLite in Android [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Delete records from SQLite in Android [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Since you are not going to keep any records offline after pushing to server. you can just delete all the records of the table after the successful API call. public void deleteAll(String tableName){ SQLiteDatabase db = this.getWritableDatabase(); db.execSQL("DELETE FROM "+tableName); db.close(); } if you plan to keep records offline you can have a separate ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-28T15:41:00+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Delete records from SQLite in Android [closed]\",\"datePublished\":\"2022-08-28T15:41:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/\"},\"wordCount\":147,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"android\",\"sqlite\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/\",\"name\":\"[Solved] Delete records from SQLite in Android [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-08-28T15:41:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Delete records from SQLite in Android [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Delete records from SQLite in Android [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Delete records from SQLite in Android [closed] - JassWeb","og_description":"[ad_1] Since you are not going to keep any records offline after pushing to server. you can just delete all the records of the table after the successful API call. public void deleteAll(String tableName){ SQLiteDatabase db = this.getWritableDatabase(); db.execSQL(\"DELETE FROM \"+tableName); db.close(); } if you plan to keep records offline you can have a separate ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/","og_site_name":"JassWeb","article_published_time":"2022-08-28T15:41:00+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Delete records from SQLite in Android [closed]","datePublished":"2022-08-28T15:41:00+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/"},"wordCount":147,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["android","sqlite"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/","name":"[Solved] Delete records from SQLite in Android [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-08-28T15:41:00+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-delete-records-from-sqlite-in-android-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Delete records from SQLite in Android [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/5468","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=5468"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/5468\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=5468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=5468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=5468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}