CODEWITHSUNDEEP
androidandroid-sqlite
Error
Error

Reputation: 830

How delete row without deleting its _ID column value?

i want save number of _ID column in sqlite if its row deleted 

  if( deleting row in sqlite table without delete _ID column if it "_ID" declared as  `INTEGER PRIMARY KEY`== true)
     {How() ;}
  else{do_not_vote_this_question_down();} .

thanks in advance !

Upvotes: 1

Views: 1004

Answers (1)

Andrew Breen
Andrew Breen

Reputation: 695

Using this as a guide to how to use SQL updates in SQLite, you shouldn't delete the row, instead update the values of all other columns to be null.

The SQL to achieve this would look like the below:

UPDATE YourTable SET column1 = null, column2 = null WHERE someCondition = 'value'

Update is used because the ID column of a row represents the unique identifier of a record. If you need to keep this value, you are updating that row, as deleting the row by design will remove all references to that ID.

I question why you need to clear out the data but keep the ID - if you are looking to mark something as "deleted" but keep it for historical purposes, a column should be added called "deleted" that is default false, and then set to true (if you do need to re-access this row).

Upvotes: 3

Related Questions