Handy77
11th May 2016, 23:05
ref = self.ref_lineEdit.text()
connection = sqlite3.connect("db.db")
result = connection.cursor()
result = connection.execute("SELECT * FROM order WHERE ref = '"+ref+"'")
data = result.fetchall()
connection.close()
I want to get the information from database table to display all rows on a qttable. Can some help me get this information to display on table. like a list
thank you
connection = sqlite3.connect("db.db")
result = connection.cursor()
result = connection.execute("SELECT * FROM order WHERE ref = '"+ref+"'")
data = result.fetchall()
connection.close()
I want to get the information from database table to display all rows on a qttable. Can some help me get this information to display on table. like a list
thank you