Update A Record With SQLite - Python Tkinter GUI Tutorial #22

Update A Record With SQLite. 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 update a record. We'll create a new window that allows us to edit and update a record in our sqlite database. Part 1 of 2.

✅ 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:

[meaningfullife]

12:40 That for loop is not necessary, you are editing just one record so you had to make it loop inside one record and without mentioning all the feilds of the one record :)

[Lennardish]

He;llo John, with all the help of your explanations, I succeeded in having the update entry boxes in the root window. My root.geometry("750x600") is wide enough to have two sets of entry boxes next to each other. It took quite some thinking but finally it succeeded. Well, it is in fact just followint the instructions of the leader :) Thanks again.

[Lennardish]

Hello John, very clear your explanaion of queries. Maybe I missed something, but suppose there is a database, fir insyance of a VERY LARGE Family, with their birthdays. How can I select just ONE name from the database, and see on screen the information I need, just to be not rude to have forgotten their birthday^^?

[exxzam]

hey thanks for the video. i have a problem that when i turn the project i made by tkinter and sqllite to an exe file it doesn't open and say can execute script file. can you help me with that? is because i'm using sqllite with it?

[SwatcomComputers]

Sir I have a question...
mydb.execute ("select *from purchasetable where purhdate=?", [ mydate1.entry.get ()])
This query returns accurate data
from my date picker widgets or database...
But i have 2 dates choosers..the 2nd one is mydate2..now what should i do chanhes to this query to get records between these 2 date pickers...these date pickers are ttkbootstrap's offsprings...thank you

[noonegaming]

For updation
when i use as you said entry object.insert it showing this error...





entry_name.insert(0, record[0])
AttributeError: 'NoneType' object has no attribute 'insert'

[morrow.himself]

How can I add the last name instead of adding the ID. I've been working on it for a long time, but I can't do it

[elmo]

cursor.execute("SELECT FROM address WHERE oid ="+record_id ) sqlite3.operationalError: incomplete input
can someone help me

[Raxer_th]

In this video you create a new window with the "normal root" way. Hope you understand that) But in a previous you told us to use the Toplevel way. What are the differences?

[Lennardish]

Hello John, love your video's. I have tried to change the addresses database program. What I wanted was that I could find just one very specific record by asking : "What name are you looking for?" For instance like this:
person = input("What name are you looking for? : ")
The result should be that the program produces that one record with the data of that person. I was not successful. Can you please give some nformation about how to have that desired result? Thanks, Paul . Netherlands

[firezerwudneh]

Great tutorials !! Wanted to ask ...does opening a new window with the Toplevel commnad differ from using the tk??

[vamprock]

cursor.execute("SELECT * FROM address WHERE oid ="+ _oid_)
sqlite3.OperationalError: incomplete input
I am getting this error
can you pls help

[dizzydizzy]

In my database, not all the fields consist of text. Some of them are sliders from 1 to 5, and checkboxes Ho do I 'insert' the info from sliders and checkboxes into the edit function since neither sliders nor checkboxes have the 'insert' attribute?
Thank you for your videos!

[GSYoutubeChannel]

Don't understand why you wouldn't use a Toplevel() window for this new window. In a previous video, you said to use Toplevels - surely you shouldn't deviate from this methodolgy?

[fredsmean]

Should I close the database connection at the end of the function? "Editor" or i called mine "update" function. To clarify. If so where do I place the connection closing statements.

[zachfenton]

Great video, i have a problem with record_id = delete_box.get(). It's saying its not finding get().

[prajwalghatage]

For def edit execution (c.execute) it is giving incomplete input error

[matejkrenek]

Hello,
I have such a problem with update a record.
When I click on the 'save record' button in second window (window where you can edit a record) it
writes to me: c.execute("""UPDATE addresses SET
sqlite3.OperationalError: no such column: zipcode"
I even tried to copy your code from github.
Do you know how to fix it?

[dianabor]

i am currently enrolled in your codemy course and need the source code for this please?