▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My TH-cam 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 ▶️ Get The Code bit.ly/3eWGKQo
Hey John. I must say this is a really great series and I'm enjoying it so much. You're a great teacher and I am learning loads. I'm just about getting to grips with the grid system and some of its gotchas and anomalies which can really be frustrating sometimes. I've also been keeping busy and following you on a few courses. Keep up the good work. 👍
Hi John, I've been following along on this Playlist for quite a while. Thanks very much for this, I've learned a lot from you. I was wondering if there's a convenient way to INSERT a database entry at a particular rowid, not just adding one at the end, or whether I need to make a function myself to do this. I appreciate for a CRM tool this may not be very useful/necessary, but I'm working on something analogous to this, but in my project the order of the database entries is important. I want to be able to insert database entries at a particular rowid, have the entries after it automatically renumber to be rowid+1 (I suppose sqlite3 can handle this automatically due to autoincrement from the primary key). Just wonder if there's an easy way to do this or whether you will/can cover this in future? Cheers.
you just add it at the end in the normal way, the rowid can't be important, because each record is a unique rowid...so if you have 5, 6, 7 etc you can't put a new one in 6...6 already has one. You can edit 6, but you can't push everything down and make a new 6. That's not how databases work, really ever.
Hi john. Is coming up with primary key compulsory? Because I need to keep my original ID column which is not simply 1, 2, 3, 4... (e.g. 10249, 02930). Using the primary key it seems to mess up my column order and from following your steps it seems like we are letting go of the original ID..
Hey there, addding from ctypes import windll windll.shcore.SetProcessDpiAwareness(1) before your Tkinter code makes the window much clearer! Can you show this is one of your upcoming Tkinter episodes? Thanks!
if you set the original ID to primary key, it seems to mess up the tuple index. When I tried to convert py to exe, it says index error tuple out of range.
The video is great but if you may do something with FOREIGN KEY, it'll be great. It's very difficult to find a clear tutorial talking about SQLite3 foreign key and tkinter. Please do something about that.
Hello, John brother. Are you okay? How are you? Which state and city in the United States do you live in now? (Maybe this information would be useful for me if I wanted to meet you)
▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My TH-cam 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
▶️ Get The Code
bit.ly/3eWGKQo
Hey John. I must say this is a really great series and I'm enjoying it so much. You're a great teacher and I am learning loads. I'm just about getting to grips with the grid system and some of its gotchas and anomalies which can really be frustrating sometimes. I've also been keeping busy and following you on a few courses. Keep up the good work. 👍
Glad you're enjoying the videos!
THANK YOU! I missed this video the first time through and that primary key was kicking my butt. Haha
Ha, glad you got it sorted!
Yeaaah my favorite course, thanks for sharing you awesome
Thanks for watching!
thank u sir
it greatly helped me in completing my cs project
Hi John, I've been following along on this Playlist for quite a while. Thanks very much for this, I've learned a lot from you. I was wondering if there's a convenient way to INSERT a database entry at a particular rowid, not just adding one at the end, or whether I need to make a function myself to do this. I appreciate for a CRM tool this may not be very useful/necessary, but I'm working on something analogous to this, but in my project the order of the database entries is important. I want to be able to insert database entries at a particular rowid, have the entries after it automatically renumber to be rowid+1 (I suppose sqlite3 can handle this automatically due to autoincrement from the primary key). Just wonder if there's an easy way to do this or whether you will/can cover this in future? Cheers.
you just add it at the end in the normal way, the rowid can't be important, because each record is a unique rowid...so if you have 5, 6, 7 etc you can't put a new one in 6...6 already has one. You can edit 6, but you can't push everything down and make a new 6. That's not how databases work, really ever.
thank you very much, its help a lot
You're welcome!
Excellent ing.
thanksing
Hi john. Is coming up with primary key compulsory? Because I need to keep my original ID column which is not simply 1, 2, 3, 4... (e.g. 10249, 02930). Using the primary key it seems to mess up my column order and from following your steps it seems like we are letting go of the original ID..
you can have a primary key and an id field...you can have as many fields and columns as you want.
@@Codemycom Yeah... I thought about it and I ended up going back to add another column. Thanks John.
4:58
BOOM now you see
it has the rowid,
wich is in fact the primary key
Goethe would be proud of you
lol
You are very good
Thank you!
Loved the video John...You made me think everybody can code..Is there any plan to have some videos about web scraping??
Glad you're enjoying them! I've done a little web scrapping...check the tkinter bitcoin price grabber video
Hey there,
addding
from ctypes import windll
windll.shcore.SetProcessDpiAwareness(1)
before your Tkinter code makes the window much clearer!
Can you show this is one of your upcoming Tkinter episodes? Thanks!
never heard of it
can you make a vid on it pls
@@bobdoe5218 No, I never heard of it
if you set the original ID to primary key, it seems to mess up the tuple index. When I tried to convert py to exe, it says index error tuple out of range.
You likely did something else wrong
love it ....
Thanks!
The video is great but if you may do something with FOREIGN KEY, it'll be great. It's very difficult to find a clear tutorial talking about SQLite3 foreign key and tkinter.
Please do something about that.
John brother! Please make video about Algorithms and Data structures
Noted
💪
:-)
Comment for me ->Had problem with columns out of order
I have a database set up for excel with 180 inputs lol so it’s around 1,500 lines of code
wow
Hello, John brother. Are you okay? How are you? Which state and city in the United States do you live in now? (Maybe this information would be useful for me if I wanted to meet you)
I live in Las Vegas
why?
Do you want to meet me? (I wanted to meet you) Do you know MIT? (Would you recommend MIT to me)
No sorry, I don't meet people from youtube
No. I'm not big man. I'm 15 years old