Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionOption Compare Database Private Sub Commande2_Click() 'Définition de Var Dim rstResultats As DAO.Recordset Dim rstCount As Integer Dim nouvTable As String Dim ancTable As String Dim mySqlCreate As String Dim myCounter As Integer Dim mySqlReqSupp As String Dim mySpc As String 'Setup variables Set rstResultats = CurrentDb.OpenRecordset("TableTermes0") rstCount = rstResultats.RecordCount mySpc = "+" 'Création des tables supplémentaires For myCounter = 1 To rstCount nouvTable = "TableTermes" & myCounter ' myCounterBack = myCounter - 1 ancTable = "TableTermes" & myCounter - 1 mySqlCreate = "CREATE TABLE " & nouvTable & " ([NumTermReq] Integer, [RequeteCombinee] text (255))" DoCmd.RunSQL mySqlCreate mySqlReqSupp = "INSERT INTO " & nouvTable & "(NumTermReq,RequeteCombinee) " mySqlReqSupp = mySqlReqSupp & " SELECT T1.NumTermReq + T2.NumTermReq, T1.RequeteCombinee & " & mySpc & " & T2.RequeteCombinee FROM " mySqlReqSupp = mySqlReqSupp & ancTable mySqlReqSupp = mySqlReqSupp & " AS T1, " mySqlReqSupp = mySqlReqSupp & ancTable mySqlReqSupp = mySqlReqSupp & " AS T2" DoCmd.SetWarnings False DoCmd.RunSQL mySqlReqSupp DoCmd.SetWarnings True Next End Sub
T1.RequeteCombinee & '" & mySpc & "' & T2.RequeteCombinee FROM "
Option Compare Database Private Sub Commande2_Click() 'Définition de Var Dim rstResultats As DAO.Recordset Dim rstTemp As DAO.Recordset Dim rstCount As Integer Dim myCounter As Integer Dim nouvTable As String Dim ancTable As String 'Dim ancTable2 As String Dim origTable As String Dim mySqlCreate As String Dim mySqlReqSupp As String Dim mySpc As String 'Setup variables Set rstResultats = CurrentDb.OpenRecordset("TableTermes0") rstCount = rstResultats.RecordCount mySpc = "+" 'Création des tables supplémentaires For myCounter = 1 To rstCount nouvTable = "TableTermes" & myCounter ancTable = "TableTermes" & myCounter - 1 'ancTable2 = "TableTermes" & myCounter - 2 origTable = "TableTermes0" mySqlCreate = "CREATE TABLE " & nouvTable & " ([NumTermReq] Integer, [RequeteCombinee] text (255))" DoCmd.RunSQL mySqlCreate mySqlReqSupp = "INSERT INTO " & nouvTable & " (NumTermReq,RequeteCombinee) " mySqlReqSupp = mySqlReqSupp & " SELECT T1.NumTermReq + T2.NumTermReq, T1.RequeteCombinee & '" & mySpc & "' & T2.RequeteCombinee FROM " If myCounter = 1 Then mySqlReqSupp = mySqlReqSupp & ancTable & " AS T1, " mySqlReqSupp = mySqlReqSupp & ancTable & " AS T2" Else mySqlReqSupp = mySqlReqSupp & ancTable & " AS T1, " mySqlReqSupp = mySqlReqSupp & origTable & " AS T2" End If DoCmd.SetWarnings False DoCmd.RunSQL mySqlReqSupp DoCmd.SetWarnings True 'Et là ce qui me pose problème !!! 'rstTemp = CurrentDb.OpenRecordset(nouvTable) 'With rstTemp 'Do While Not .EOF 'Un truc du type If TablesTermes0.RequeteCombinee is in nouvelenregestriment >1 then delete 'mySqlreqDoubTerm = " SELECT T3.NumTermReq, T3.RequeteCombinee FROM " & nouvTable & " WHERE (((TablesTermes0.RequeteCombinee) " 'mySqlreqDoubTerm = mySqlreqDoubTerm & " In (SELECT [RequeteCombinee] FROM [" & nouvTable & "] As T3 GROUP BY [NumTermReq] HAVING Count(*)>1 ))) " 'mySqlreqDoubTerm = mySqlreqDoubTerm & " ORDER BY TableTermes1.NumTermReq " 'DoCmd.SetWarnings False 'DoCmd.RunSQL mySqlreqDoubTerm 'DoCmd.SetWarnings True '.MoveNext 'Loop 'End With Next End Sub
dans TableTermes1
Terme1+Terme1
ou Terme2+Terme2
et dans TableTermes2
Terme1+Terme1+Terme2
ou Terme1+Terme2+Terme1
mysqlcreate = "create table " & nouvtable & " ([numtermreq] integer, [requetecombinee] text (255))" docmd.runsql mysqlcreate mysqlreqsupp = "insert into " & nouvtable & " (numtermreq,requetecombinee) " mysqlreqsupp = mysqlreqsupp & " select t1.numtermreq + t2.numtermreq, t1.requetecombinee & '" & myspc & "' & t2.requetecombinee from "