Update A Record With SQLite Part 2 - Python Tkinter GUI Tutorial #23

Показать описание

How to 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 the code that actually updates the record in our sqlite database. Part 2 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

Рекомендации по теме

Комментарии

▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My YouTube Channel:
▶️ See More At: ✅ Join My Facebook Group:

Codemycom

Someone is sitting in the shade today because someone planted a tree a long time ago. Appreciate your efforts. This series has helped me a lot. Thanks a lot.

ajinkyasonwane

he deserves so more he keeps on creating so good videos I hope you will touch stars one day coz you are awesome

sulekhabaranwal

Thanks, John. You are a great teacher!

bhattvd

jhon keeps bumping his head into different things every week

oh also thanks for the awesome content.(really without you i wouldn't have made my project)

itsomegali

Uppppssss! Hope you are not badly hurt John!!

HugoCervantes-HARO

I might be getting a head of the lessons but would be nice to offset the new window when it opens instead covering the current window?

ConcertLD

Exception in Tkinter callback
Traceback (most recent call last):
File "C:\Python\Python39\lib\tkinter\__init__.py", line 1885, in __call__
return self.func(*args)
File "C:\Users\azmin\latihan pbd\databasepasien.py", line 40, in update
c.execute("""UPDATE addresses SET
sqlite3.OperationalError: no such column: tanggal_lahir

sir please clarify I getting tied

azmanbokir

Hey @Codemy.com I keep getting an error that says the following.

'oid': record_id
sqlite3.OperationalError: near "text": syntax error

Any help would be appreciated. Thanks!

XxCadrosxX

hi!
in 11:51 i have an syntax error
'oid' : record_id

Syntax Error = no such column: addresses

i copied your code in github and same syntax error
plz replay i need help to that

AliFGT

awesome videoseries. the explanations are nice and clear. helped me a lot to do some own works and project. love your videos and the way how you teach :)

blumenzupfer

Love the videos. Very easy to follow and understand. Thank you so much for providing these!! Quick question tho. I’m new to a bunch of this stuff. Is this a standalone program that needs to be stalled on a computer or would your program be ran inside a browser window? Also does this program as it sits, have the functionality to be opened in many different instances by multiple users and allow them to create, update and delete records from the GUI or limited to single user? Thanks for taking the time to provide this content and for reading my questions

dsmdan

Thank you for your efforts and clear explanations! :)

masekin

Thank you sir it helps me a lot on my project...thank you so much

Shaktiswaruppsingh

is there a way to search the database for a string or collection of strings?

EDIT: found a way to search using LIKE but its only pulling one record even with fetchall() and fetchmany() and it also has to match the entry in that column exactly, so if i have a name and want to search for it partially

EDIT 2: so this is where im at (made it easier to read)
cursor.execute("
SELECT *, oid
FROM customer
WHERE f_name
IN Customer
LIKE :name", ('name': (f_name.get(), )))

basically what im trying to do is make a button for looking up names in the database and displaying them to a label

Corcontv

Thanks for your video. I learnt a lot for your videos. I have one question on this video. Why don't you use toplevel() to create the edit window instead of creating it just like root?

leetimothy

Day 95: Still waiting for the next video in this project series. :D

mm-et

Hey John thank you very much for your videos. Is there concern with sql injection when we put SET first_name = :first WHERE oid = :oid - Should we instead be using a place holder like =? Or is this not a concern with certain projects that may not be on the internet? Thanks again for your insight

ClaytonMcKinley

Very good .. when you are doing other Video on this you mention on the end

habib-urrehman

5:15, in mycase the primary key to be compared is a varchar type, how would i compare it
c.execute("SELECT * FROM matchs where match_id="+ to_update_match_id
)
varchar type content is written in to_update_match_id

guitarec

Update A Record With SQLite Part 2 - Python Tkinter GUI Tutorial #23

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

Update A Record With SQLite Part 2 - Python Tkinter GUI Tutorial #23

Updating records - DB Browser for SQLite - part 6

Android SQLite Database Tutorial - Add, Update and Delete Record

How to Insert Update Delete Record in SQLite Database using VB Net

Update and Delete Commands Alter Tables Create and Manage SQLite Databases From Scratch

Update Statements in SQLite - SQLite Tutorial - How to Update Data

SQLite in Python | (Update Query) Update A Record With SQLite | Python SQLite Tutorial #41

How to update and delete a record from sqlite in swift5

SQLite | 02 Improve Update Record | Android Studio | Java

Update Record Sqlite in Java || Java Database Update

SQLite - UPDATE

Python Programming 81 - Update SQLite Data in Python

SQLite Tutorial #11: Update and Delete Record in SQLite

SQLite Tutorial Part 13 - UPDATE ROWS IN TABLE

How to use UPDATE using SQLite

Android Studio - SQLite Database Create Read Update Delete with Prepared Statement Examples

Selecting Inserting Deleting and Updating SQLite Records

How to update SQLite record by using Parameterized Queries with PDO in PHP : A6

Updating SQLite Records Using PHP PDO | Step-by-Step Guide #sqlite #updateSQL #sql

UPDATE RECORD IN JAVA NETBEANS DENGAN SQLITE

95. Update Record-Sqlite

UPDATE a Record in Database table | Part - 06: C++ and SQLite Tutorial

The Secret to MASTERING SQLite Record Updates