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

Having problems with the icon on the Update window. Current version has me using PhotoImage to import the .ico file to a variable and the iconphoto property for the window. This works fine on the main window but not the new window with an error message saying; can't use "pyimage2" as iconphoto: not a photo image... Any ideas?

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

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.

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

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

Is the source code available?

Can you explain how to save image to sqlit3 database, and how to read it using tkinter please

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

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

Nice

Would it be possible to have the the gui autoupdate when something in the database changes, or after a specific time like every second to keep up to date with the database?

Error is showing that—

list index out of range

Sir why can't u use toplevel for opening a new window

The update functions updates everything...

How we can save the Data created in excel

This helped a lot.. Thanks :)

Why isn’t my data appearing?

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.

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

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!

amazing !!! U SHOULD KNOW THAT I LOVE YOU XD

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?

incomplete input error?

Thank you for the video.While I am trying to execute this code I had an error like "name editor is not defined" on jupyter notebook.pls help me in this regard...

Hi, thank you very much for your video.

Hi, thank you very much for your video.

I have all my 'items' 'strings' listed into a TreeView and I'm trying to make the same 'update record' from the SQLite DB. Could someone give me a hand, please?

vid idea: make a code editor in tkinter

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?

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

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?

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?

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

Thanks very wel explained

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'