▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My RUclips 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
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 :)
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.
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?
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'
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^^?
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
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?
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 :)
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?
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.
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!
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
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?
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...
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?
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.
@@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.
@@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.
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?
▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My RUclips 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
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 :)
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.
Glad to hear it!
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?
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'
Great tutorials !! Wanted to ask ...does opening a new window with the Toplevel commnad differ from using the tk??
Yes, it can differ in small ways.
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^^?
cursor.execute("SELECT FROM address WHERE oid ="+record_id ) sqlite3.operationalError: incomplete input
can someone help me
same problem :/
for the people of the future, its probably because your id number entry column is empty
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
This helped a lot.. Thanks :)
Very welcome
Thanks very wel explained
Thanks for watching!
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?
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 :)
cursor.execute("SELECT * FROM address WHERE oid ="+ _oid_)
sqlite3.OperationalError: incomplete input
I am getting this error
can you pls help
cursor.execute("SELECT * FROM address WHERE oid ="+( _oid_))
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?
You can do either. It depends on how you're going to use the window
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.
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!
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
I have videos on the playlist that show you how to do that
amazing !!! U SHOULD KNOW THAT I LOVE YOU XD
Thanks!
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?
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
For def edit execution (c.execute) it is giving incomplete input error
check your code
Great video, i have a problem with record_id = delete_box.get(). It's saying its not finding get().
What did you do different from the video?
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
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...
Don't use juypter notebooks for tkinter
Hi, thank you very much for your video.
Thank you too
i am currently enrolled in your codemy course and need the source code for this please?
All the code for this playlist is at: github.com/flatplanet/Intro-To-TKinter-RUclips-Course
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?
Sure, I have videos on timers on the playlist
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.
@@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.
@@Xboerefijn1 tnx man
Can you explain how to save image to sqlit3 database, and how to read it using tkinter please
save/read it as a blob type, in the same way you save anything
@@Codemycom but only displaying bainery code😥😥😥
@@Music-bo8ig then you did it wrong
@@Codemycom so what is the correct method can you tell us pleas
@@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.
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?
I'll likely do videos on treeview soon
Sir why can't u use toplevel for opening a new window
You can
The update functions updates everything...
vid idea: make a code editor in tkinter
Yeah I might do that in the future
Error is showing that-
list index out of range
What did you do differently from the video?
Sorry ! I got my mistake 😅
@@Cric_shorts4091 glad you got it sorted out
How we can save the Data created in excel
I have a course on python and excel with openpyxl
Is the source code available?
github.com/flatplanet/Intro-To-TKinter-RUclips-Course
Why isn’t my data appearing?
You messed up the code somewhere
incomplete input error?
I need more info than that. What's the entire error.
Hi, thank you very much for your video.
Thank you too