Python Tutorial GUI/Desktop app - Connection to DataBase/Populate Combo Box - part 5

[Daniel-nnoy]

In Sqlite3 I followed this path and it worked very well.




def fornCombo(self):
try:
self.banco = sqlite3.connect('Vendas.db')
self.cursor = banco.cursor()
cursor.execute("SELECT * FROM Fornecedor")
for row in enumerate (cursor):
if row[1]:
data = row[1]
Nome = data[1]


except Exception:
msg = QMessageBox()
msg.setText("Erro ao carregar Fornecedores")
msg.setWindowTitle("Erro!")
| QMessageBox.Cancel)
msg.exec_()


But your video showed me the way, I just adapted to Sqlite3 Thanks!

[pragatics]

Thanks sir.It's very helpfull video

[pragatics]

sir plz make a video which is related to school financial system

[Daniel-nnoy]

Hello can you help me?
I inserted data from a database table into my comboBox
Now I need to get the ID of this Table when I select the item in the ComboBox to insert in the foreign key of my second table. Can you do that?

[kanishkakumarasiri]

How to make this Combobox autocompleate