clements42 | bonjour, voici mon soucis
je dois faire une requête insert dans une base access. Soucis, elle ne fonctionne pas. Ce qui est surprenant, c'est que VB ne me donne aucun message d'erreur, je constate kiste après coup que la table reste désespérément vide.
malheureusement celle-ci est très longue, la table comportant 130 champs. voici la requête, juste pour vous donner un aperçu
Spoiler :
sql = "insert into resultatJoueurAmisco " & _
" values (" & idJoueur & "," & idMatch & "," & Cells(4, 2) & "," & Cells(4, 3) & "," & Cells(4, 4) & "," & Cells(5, 2) & "," & Cells(5, 3) & "," & Cells(5, 4) & "," & Cells(6, 2) & "," & Cells(6, 3) & "," & Cells(6, 4) & "," & Cells(7, 2) & "," & Cells(7, 3) & "," & Cells(7, 4) & "," & Cells(8, 2) & "," & Cells(8, 3) & "," & Cells(8, 4) & "," & Cells(9, 2) & "," & Cells(9, 3) & "," & Cells(9, 4) & "," & Cells(12, 2) & "," & Cells(12, 3) & "," & Cells(12, 4) & "," & Replace(Cells(13, 2), ",", "." ) & "," & Replace(Cells(13, 3), ",", "." ) & "," & Replace(Cells(13, 4), ",", "." ) & "," & _
"" & Cells(14, 2) & "," & Cells(14, 3) & "," & Cells(14, 4) & "," & Replace(Cells(15, 2), ",", "." ) & "," & Replace(Cells(15, 3), ",", "." ) & "," & Replace(Cells(15, 4), ",", "." ) & "," & Cells(16, 2) & "," & Cells(16, 3) & "," & Cells(16, 4) & "," & Replace(Cells(17, 2), ",", "." ) & "," & Replace(Cells(17, 3), ",", "." ) & "," & Replace(Cells(17, 4), ",", "." ) & "," & Cells(18, 2) & "," & Cells(18, 3) & "," & Cells(18, 4) & "," & Replace(Cells(19, 2), ",", "." ) & "," & Replace(Cells(19, 3), ",", "." ) & "," & Replace(Cells(19, 4), ",", "." ) & "," & Cells(20, 2) & "," & Cells(20, 3) & "," & Cells(20, 4) & "," & _
"" & Cells(21, 2) & "," & Cells(21, 3) & "," & Cells(21, 4) & "," & Cells(23, 2) & "," & Cells(23, 3) & "," & Cells(23, 4) & "," & Cells(24, 2) & "," & Cells(24, 3) & "," & Cells(24, 4) & "," & Replace(Cells(25, 2), ",", "." ) & "," & Replace(Cells(25, 3), ",", "." ) & "," & Replace(Cells(25, 4), ",", "." ) & ",'" & Format(Cells(26, 2), "hh:mm" ) & "','" & Format(Cells(26, 3), "hh:mm" ) & "','" & Format(Cells(26, 4), "hh:mm" ) & "'," & Cells(27, 2) & "," & Cells(27, 3) & "," & Cells(27, 4) & "," & Cells(28, 2) & "," & Cells(28, 3) & "," & Cells(28, 4) & "," & Replace(Cells(29, 2), ",", "." ) & "," & Replace(Cells(29, 3), ",", "." ) & "," & Replace(Cells(29, 4), ",", "." ) & "," & _
"" & Cells(31, 2) & "," & Cells(31, 3) & "," & Cells(31, 4) & "," & Cells(32, 2) & "," & Cells(32, 3) & "," & Cells(32, 4) & "," & Replace(Cells(33, 2), ",", "." ) & "," & Replace(Cells(33, 3), ",", "." ) & "," & Replace(Cells(33, 4), ",", "." ) & "," & Cells(34, 2) & "," & Cells(34, 3) & "," & Cells(34, 4) & "," & Cells(35, 2) & "," & Cells(35, 3) & "," & Cells(35, 4) & "," & Replace(Cells(36, 2), ",", "." ) & "," & Replace(Cells(36, 3), ",", "." ) & "," & Replace(Cells(36, 4), ",", "." ) & "," & Cells(37, 2) & "," & Cells(37, 3) & "," & Cells(37, 4) & "," & _
"" & Cells(38, 2) & "," & Cells(38, 3) & "," & Cells(38, 4) & "," & Replace(Cells(39, 2), ",", "." ) & "," & Replace(Cells(39, 3), ",", "." ) & "," & Replace(Cells(39, 4), ",", "." ) & "," & Int(Cells(42, 2)) & "," & Int(Cells(42, 3)) & "," & Int(Cells(42, 4)) & "," & Int(Cells(43, 2)) & "," & Int(Cells(43, 3)) & "," & Int(Cells(43, 4)) & ",'" & Format(Cells(44, 2), "hh:mm" ) & "','" & Format(Cells(44, 3), "hh:mm" ) & "','" & Format(Cells(44, 4), "hh:mm" ) & "'," & Int(Cells(45, 2)) & "," & Int(Cells(45, 3)) & "," & Int(Cells(45, 4)) & "," & Cells(46, 2) & "," & Cells(46, 3) & "," & Cells(46, 4) & "," & Int(Cells(47, 2)) & "," & Int(Cells(47, 3)) & "," & Int(Cells(47, 4)) & "," & Cells(48, 2) & "," & Cells(48, 3) & "," & Cells(48, 4) & " )" |
ma question : quelles sont les bonnes méthodes de travail lorsqu'il s'agit de gérer des requetes de telles longueurs ? c'est très long à écrire, et encore plus chiant à débugguer quand il y a un problème comme dans mon cas.
Merci d'avance. |