Can i delete places sqlite

Learn More. Chosen solution If you use Sync then best is to disconnect Sync temporarily during troubleshooting. Chosen Solution If you use Sync then best is to disconnect Sync temporarily during troubleshooting.

If you use Sync then best is to disconnect Sync temporarily during troubleshooting. TomC see here for table definitions: developer. Still unclear what the children you are referring to are. Sounds like you can already find them. As a general tip - I would find the first row for each of your duplicate sets, modify all the other rows so they refer to the first, then delete the duplicates. Tom the children are the subfolders and bookmarks, all in the same table, using the parent column.

I'm thinking it would require a recursive query to get them all. You'd have to get all the children for each dup, move them to one it doesn't matter which , and then finally delete the dups. All of this is a bit beyond my expertise.

Show 3 more comments. Active Oldest Votes. Do it all set based rather than trying to loop through anything using a cursor. TopID, b. TomC TomC 2, 1 1 gold badge 6 6 silver badges 16 16 bronze badges. I have edited my question to try and make it more clear. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete?

Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Related 7. Hot Network Questions. Question feed. We will never ask you to call or text a phone number or share personal information. This thread was archived. Please ask a new question if you need help. When you delete the places.