i have 2 problems with the code below:
although Client, Models, etc., defined as TEXT, while entering values in text, the program crash. but if i enter numbers, it continue.
the other problem is, after entering the data (using the input), i get this error message:
although Client, Models, etc., defined as TEXT, while entering values in text, the program crash. but if i enter numbers, it continue.
the other problem is, after entering the data (using the input), i get this error message:
Output:client: 56
model: 45
quantity: 345
order date: 345
Delivery date: 45
Traceback (most recent call last):
File "/Users/davidfrucht/PycharmProjects/untitled1/DFSL.py", line 22, in <module>
dynamic_data_entry()
File "/Users/davidfrucht/PycharmProjects/untitled1/DFSL.py", line 18, in dynamic_data_entry
(client, model, quantity, order_date, delivery_date))
sqlite3.OperationalError: no such table: orders
Process finished with exit code 1
here is the codeimport sqlite3 conn = sqlite3.connect('dfsl.db') c = conn.cursor() def create_table(): c.execute("CREATE TABLE orders (Client TEXT, Model TEXT, Quantity INTEGER, Order_date TEXT, Delivery_date TEXT)") def dynamic_data_entry(): client = input("client: ") model = input("model: ") quantity = input("quantity: ") order_date = input("order date: ") delivery_date = input("Delivery date: ") c.execute("INSERT INTO orders (Client, Model, Quantity, Order_date, Delivery_date) VALUES (?, ?, ?, ?, ?)", (client, model, quantity, order_date, delivery_date)) conn.commit() dynamic_data_entry() conn.close()