1 2 3
| txtSQL = ""
txtSQL = "INSERT INTO [CI] ([matricule],[nom],[prenom],[annee],[CI1_mnemonic],[CI1_nom_cours],[CI1_TH],[CI1_TP],[CI1_EX],[CI2_mnemonic],[CI2_nom_cours],[CI2_TH],[CI2_TP],[CI2_EX],[CI3_mnemonic],[CI3_nom_cours],[CI3_TH],[CI3_TP],[CI3_EX],[CI4_mnemonic],[CI4_nom_cours],[CI4_TH],[CI4_TP],[CI4_EX]) VALUES (matricule, nom, prenom, annee, mnemonicCI1, hfCI1, hfCI1TH, hfCI1TP, hfCI1EX, mnemonicCI2, hfCI2, hfCI2TH, hfCI2TP, hfCI2EX, mnemonicCI3, hfCI3, hfCI3TH, hfCI3TP, hfCI3EX, mnemonicCI4, hfCI4, hfCI4TH, hfCI4TP, hfCI4EX)"
cnn.Execute(txtSQL) |
Partager