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

haraguchi
113
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 ♦♦
4525612
accept rate: 9%

Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

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:

×191

question asked: 08 Jun '16, 04:51

question was seen: 1,503 times

last updated: 22 Jun '16, 06:51