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

[@Codemycom]

▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My KZbin Channel: bit.ly/2UFLKgj bit.ly/2IGzvOR ▶️ See More At: ✅ Join My Facebook Group: Codemy.com bit.ly/2GFmOBz ▶️ Learn to Code at Codemy.com ✅ Buy a Codemy T-Shirt! Take $30 off with coupon code: youtube1 bit.ly/2VC9WUN

[@meaningfullife7075]

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

[@elmo5269]

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

[@mrrobot3771]

same problem :/

[@vidhiney]

for the people of the future, its probably because your id number entry column is empty

[@vamprock02]

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

[@piwassana]

cursor.execute("SELECT * FROM address WHERE oid ="+( _oid_))

[@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.

[@Codemycom]

Glad to hear it!

[@no-one-gaming-]

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'

[@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?

[@sailendrachettri8521]

If you create with using Toplevel, then whenever you close the main window the other window will also close automatically. but if you create using TK() then it not affected. Hope that make sense :)

[@mahdiolamaei4021]

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?

[@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^^?

[@GS2YoutubeChannel]

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?

[@Codemycom]

You can do either. It depends on how you're going to use the window

[@prajwalghatage7968]

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

[@Codemycom]

check your code

[@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

[@Codemycom]

I have videos on the playlist that show you how to do that

[@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

[@firezerwudneh85]

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

[@Codemycom]

Yes, it can differ in small ways.

[@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

[@matejkrenek5933]

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?

[@Codemycom]

Sorry, there's a problem with your code, or you haven't created a zipcode column in your database...either way I don't know how to fix it

[@dizzydizzy4704]

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!

[@zachfenton608]

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

[@Codemycom]

What did you do different from the video?

[@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.

[@bakiyakannan3746]

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...

[@Codemycom]

Don't use juypter notebooks for tkinter

[@gayatrinadar5192]

This helped a lot.. Thanks :)

[@Codemycom]

Very welcome

[@dianabor188]

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

[@Codemycom]

All the code for this playlist is at: github.com/flatplanet/Intro-To-TKinter-KZbin-Course

[@srbhiscock]

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?

[@Codemycom]

make your image variable global...though, not sure what you mean by "current version has you doing"...there is no current version requirement that's any different from any of my videos.

[@dmskarunaratne80]

try using - editor=tk.Toplevel(root). it works. ( multiple instances of Tk will not work in usual way for image handling)

[@fvefa]

Thanks very wel explained

[@Codemycom]

Thanks for watching!

[@aribiali3574]

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

[@Codemycom]

Thanks!

[@allifmaalengineeringlimite9853]

The update functions updates everything...

[@mee8963]

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

[@Codemycom]

You can

[@Xboerefijn1]

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?

[@Codemycom]

Sure, I have videos on timers on the playlist

[@novaploca2080]

Hi Ryan have you managed to do that, I am having trouble. Either every second program opens another instance of window or rows get inserted after last insert.

[@Xboerefijn1]

@@novaploca2080 Yes. Though I have only my main window: I went for an infinite while loop. Inside I first deleted the contents of the cell and than insert new contents. I set a sleep time of 10ms to not make it to heavy on my computer while keeping the contents of the cell always up to date and uneditable.

[@novaploca2080]

@@Xboerefijn1 tnx man

[@Music-bo8ig]

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

[@Codemycom]

save/read it as a blob type, in the same way you save anything

[@Music-bo8ig]

@@Codemycom but only displaying bainery code😥😥😥

[@Codemycom]

@@Music-bo8ig then you did it wrong

[@Music-bo8ig]

@@Codemycom so what is the correct method can you tell us pleas

[@Codemycom]

@@Music-bo8ig I don't have any videos on that because these days you don't hold images in databases, you upload them to a cdn and save the url of the image to the database as text.

[@parsabahrambeik4381]

Hi, thank you very much for your video.

[@Codemycom]

Thank you too

[@martygeorgiev6086]

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?

[@Codemycom]

I'll likely do videos on treeview soon

[@Cric_shorts4091]

Error is showing that- list index out of range

[@Codemycom]

What did you do differently from the video?

[@Cric_shorts4091]

Sorry ! I got my mistake 😅

[@Codemycom]

@@Cric_shorts4091 glad you got it sorted out

[@daneshpatel5638]

How we can save the Data created in excel

[@Codemycom]

I have a course on python and excel with openpyxl

[@rafaelperezmederos6958]

Why isn’t my data appearing?

[@Codemycom]

You messed up the code somewhere

[@mistermayhem988]

incomplete input error?

[@Codemycom]

I need more info than that. What's the entire error.

[@jaysedits9492]

Is the source code available?

[@Codemycom]

github.com/flatplanet/Intro-To-TKinter-KZbin-Course

[@generalpinochet9821]

vid idea: make a code editor in tkinter

[@Codemycom]

Yeah I might do that in the future

[@parsabahrambeik4381]

Hi, thank you very much for your video.

[@Codemycom]

Thank you too