Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

JavaScript

Darian Ross
Darian Ross
11,155 Points
Posted by Darian Ross
Darian Ross
11,155 Points

Database Records Dont Delete

I deleted all the records in the sqlite dev database and even added a force true to sync, but all the articles i entered keep coming back and wont go away. What's the secret here?

Steven Parker
Steven Parker
231,275 Points
Steven Parker
Steven Parker
231,275 Points

It might help if you show your actual code, and anything else to help someone reproduce your issue.

1 Answer

Darian Ross
Darian Ross
11,155 Points
Darian Ross
Darian Ross
11,155 Points

If I thought it to be beneficial to add any code then i would... why is this always my first answer? It's embarrassing and feel like I am not abiding by guidelines and people won't like me. Let me try to word it better, maybe that will help ...

If you'd like the code then download the project files and use the final results.

My earlier comments .. "I deleted all the records in the sqlite dev database and even added a force true to sync, but all the articles i entered keep coming back and wont go away. What's the secret here?"

Additional comments for clarification: If i run a delete execution in DB Browser and delete the record then it doesn't go away in the "Sequeliz-It!" application. It shows deleted in the database tools but the article will not delete from the application.

If this doesn't make sense, please don't ask me for code (SEE ABOVE).

Thank you for any assistance.

Darian Ross
Darian Ross
11,155 Points
Darian Ross
Darian Ross
11,155 Points

I found out there's a "Write Changes" in DB Browser. I'm used to using Azure Data Studio and MS Management Studio for my SQL and my Updates and Deletes don't need any 2nd steps ... this was right in front of my face the whole time. Haha Sorry!

Steven Parker
Steven Parker
231,275 Points
Steven Parker
Steven Parker
231,275 Points

It's always easier to help if we can reproduce the issue and see it for ourselves, which usually means we need to use the same code. If the code is just downloaded from the lesson, it would be good to provide a link to the specific lesson.

We also need to run in the same environment, so when you are using tools that are not provided by treehouse, it's also very helpful to identify them up front.

In any case, congratulations on resolving your own issue!   :+1: