We would like to remove some records from existing sqlite .db file. Could you please explain how to implement this removing?

asked 08 Jun '16, 04:51

haraguchi's gravatar image

accept rate: 0%

edited 08 Jun '16, 04:53

Dear Haraguchi,

As of now there is no easy way to do this, we will be adding a function to do this in coming versions,

Right now, as we don't have a better way, you will need to install the "SQLite Database Browser" application so that you can remove the records directly from the database.

Open the application and then open the Collect Earth database ( located in the file C:\Users\SanchezPausDiaz\AppData\Roaming\CollectEarth\collectEarthDatabase.db )

Once you open the database find the ID of the survey in the ofc_survey table.

Then you can run the query :

delete from ofc_record where of_survey_id = 1 and key1=PLOT_ID

Substitute PLOT_ID with the ID of the record you want to remove.

alt text

alt text

permanent link

answered 22 Jun '16, 06:51

Open%20Foris's gravatar image

Open Foris ♦♦
accept rate: 10%

For a newer and improved function to delete plots please see the answer to THIS QUESTION IN THE FORUM!

permanent link

answered 25 Aug '21, 09:54

Open%20Foris's gravatar image

Open Foris ♦♦
accept rate: 10%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 08 Jun '16, 04:51

question was seen: 4,098 times

last updated: 25 Aug '21, 09:54