I’m having trouble using the combobox in an external file. Basically the combobox is in the main file and I would like to use its selected value in the external file. If I select a certain item, it should help cursor.excute to search for a database table, so cursor.execute(“SELECT x FROM Table1 WH…
Tag: tkinter
In tkinter, how can I use a function in class A to populate a widget in class B?
Primary relevant code is in class EntryForm (around line 190) and class BookmarkAccess (around line 246) I am sharing the global user_id as a means of querying specific rows of data from the database, after the login is completed. My current workaround is to use a button on the final page, to populate the lis…
Problem in a function that extracts and saves fields from a database table to another
If in the combo_Nations combobox I select a specific Country (the country name is extracted from the “All_Nations” table in the “Nations_name” column), I would like to get the corresponding ID_Nations of the respective selected country (ID_Nations is found in the same table “All_…
In the Treeview I only display the ID of a line and not the remaining (empty) fields
I receive an error updating the TreeView, after clicking on the button to filter the data of a database through two comboboxes. The filtering appears to be successful, but only the staff ID is displayed in the tree view and not all related data. Without using the filter button, everything is fine. This is the…
TypeError: Argument 2 must be Tuple or List
I have built a GUI using TKinter. There I want to output the stored data and change them individually. Using the UPDATE command, I want to update the data in the table. I use MariaDB as database. I’m getting this error: Here is the complete function: Any suggestions where I’m doing wrong? Answer A…
How do I update my stock database to reduce itself once a customer orders
Time to ask from the almighty stack overflow questions again. So my problem is that I am developing in TKINTER and have implemented and integrated 2 tables in one database on the application. I would …
Updating Multiple Columns in sqlite3
I am wanting to update multiple columns in my ‘Class’ Table in sqlite. I do not know how to do this so I approached the same syntax as an ‘INSERT’ query however, I seem to be having the following syntax error: sqlite3.OperationalError: near “VALUES”: syntax error The line I…
How to convert an SQL Output to a python list [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 2 years ago. Improve this question So basically I have an SQL database with 5 different columns of data. what I am trying to do…