Delete A Record From Our Database - Python Tkinter GUI Tutorial #21

How to Delete A Record From Our Database with Python. In this series I'll show you how to create graphical user interfaces for Python with Tkinter. In this video I'll show you how to delete a record from the SQLite database in our Tkinter app.

✅ Watch The Other Videos In This Python Playlist:

▶️ See More At:

✅ Join My Facebook Group:

✅ Subscribe To My YouTube Channel:

Take $22 off with coupon code: youtube

[Codemycom]

▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My YouTube Channel:
▶️ See More At: ✅ Join My Facebook Group:

[GurpreetSingh-flbw]

I am loving the content, and honestly, I am learning a lot through your online mini-classes on YouTube. Honestly, can say that just from these videos, I am actually getting a huge foundation on python.

[bobbobster]

Last videos: Sorry for my typings, its friday in Vegas.... This video: its monday morning, u gotta bear with me... Haha, Im waiting for the next days ;) Good videos btw!! keep it up!

[stevechoatie]

Hi John. What code would be needed to show the records when there were more than what would fit in the window? I'm assuming you could place them in another window or frame with the ability to use a scroll button. Thanks!

[consultmohamedgamal]

Dear Sir
Thank you for the wonderful effort

[kjn]

15:12 I "fixed" the formatting issue by deleting the label widget when deleting the record.

query_label.grid_forget() Inside the "delete" -method.

That way you can just click the Query button and get new data "clean" without the ghost formatting.

[gyothirramaadityap]

seems like getting crazy is adding tab :):)

[narutouzomaki]

Amazing series on Tkinter 🔥 🔥

everything is working fine but there is some issue in my query label.
Can you provide the code of this video?

[dkallail]

Hi John, would you please let me know if there is a reason capitalization is used in the c.execute line of code on certain words? c.execute("DELETE from addresses WHERE oid =").

[musakayasimp]

or can you just give the whole code so i can try to fix it myself and thank you again you really are an amazing person

[AdamCraftPC]

Is it possible to change the ID of a record? so if i wanted to add a specific record to appear at a specific part of the list rather than just showing on the bottom? ( I figure changing the ID is the easiest way to do this, if not, is there another way of making that happen?)

[jimjohnson]

Thanks very much for these videos, definitely buying your course. Quick question though: I'm trying to do a similar sort of database app, but I want it such that whenever a new person is added, a tab for their name appears on the root window (Successfully done). When this tab (button) is clicked, all the other details about them (last name, address etc) should be displayed in a window. Also, when you initially start the app, tabs/buttons for all people created the last time the app was used are automatically created on the root window (successfully done). The problem I'm having is that when these buttons are clicked, they open the window with all the details for the last added person instead of for the person who's name is shown on the button. To create the buttons on the root window, I used a for loop which goes through all names within the database. For each name, it creates a button and adds it to row = n on the root window, before doing n=n+1, so that the next button is added to the row below. (All the buttons do come out in the correct places with the correct names). For the creation of each button, I am using: nameButton = tk.Button(root, text=current_name, command=lambda: accessUserData(current_name)) Where current_name is the string of the name of the person, and accessUserData is a separate function which displays all the other data about the person, given that you've provided the persons name as the argument. So for each cycle in the for loop which is creating the buttons, current_name is incrementally taking the value of each persons name within the database. I'm guessing my issue is that I've severely misunderstood how I should be mapping those assignments for each button in the for loop, but I can't figure out what I should be doing. I'm also suspecting this design I'm using would be frowned upon by those who practice good code, but really hoping you can help nonetheless!

[arulxaviervm]

which software are you using for recording your screen and face(without background)

[parsabahrambeik]

Hi, thank you very much for your video.

[iamdav]

Hi. Is it possible to delete a specific word(every time it will be another word ) instead of primaryKey, that is given from input in the box "delete"?

[markgaje]

Is there any way that I can select and delete a record from a Tree View and it will include deleting also the record from the sqlite3 database?

[mee]

Is it works if the query inside execute are in small case..?

[tl]

@15:12 When you delete the record and you say "It does some weird formatting". Is there any way when you delete a record for it to clear out that line completely.

[nowybopes]

What could I do to update oids' when I delete a record? I mean, when there are 3 records and I'll delete the 2nd one, there will be 2 records with oid 1 and 3. I need to automatically update oids' to 1 and 2. Is there any easy way to implement it?

[generalpinochet]

can you delete by name? for example, you make a variable called name, the user enters the name, and you can do c.execute("DELETE from adresses WHERE prodname="+name)