1 2 3 4
| sqlUpdate = " UPDATE T_Agent SET Matricule = " & ValeurDeMask(oblmskMatricule(0)) & ", Prenom = '" & obltxtPrenom(1) & "', Nom = '" & obltxtNom(2) & "',DateDeNaissance = " & ValeurDeMask(oblmskDateDeNaissance(3)) & ", " & _
" LieuDeNaissance = '" & txtLieuDeNaissance(4) & "', DateEmbauche = " & ValeurDeMask(mskDateEmbauche(5)) & ", Adresse = '" & txtAdresse(6) & "' , Telephone = '" & txtTelephone(7) & "',SoldeAgent = " & txtSolde(8) & ", " & _
" idFonction = (SELECT idFonction FROM T_Fonction WHERE NomFonction = '" & obldcFonction(9) & "' ),idService = (SELECT idService FROM T_Service WHERE NomService = '" & obldcService(10) & "' ),EnActivite = '" & txtActivite(11) & "',Observation='" & txtObservation(12) & "' ,Photo = '" & txtPhoto(13) & "' " & _
" WHERE Matricule = '" & frmPrincipal.Matricule & "' " |
Partager