Dim maRequete As String = "Select * From TABLE WHERE " If Filtre1 <> "" Then maRequete += "Champ1 Like '" & Filtre1 & "' And " If Filtre2 <> "" Then maRequete += "Champ2 Like '" & Filtre2 & "' And " (...) ' Suppression du dernier And, inutile ' (lignes extraites de l'aide de VB = facile à trouver) If maRequete.Trim().EndsWith(" And") Then Dim DernierePosition As Integer = maRequete.LastIndexOf(" And") If DernierePosition >= 0 Then maRequete = maRequete.Substring(0, DernierePosition) End If End If
Dim maRequete As String = "Select * From TABLE " If Filtre1 <> "" Then maRequete += "WHERE Champ1 Like '" & Filtre1 & "' And " If Filtre2 <> "" Then maRequete += "WHERE Champ2 Like '" & Filtre2 & "' And " (...) ' Suppression du dernier And, inutile ' (lignes extraites de l'aide de VB = facile à trouver) If maRequete.Trim().EndsWith(" And") Then Dim DernierePosition As Integer = maRequete.LastIndexOf(" And") If DernierePosition >= 0 Then maRequete = maRequete.Substring(0, DernierePosition) End If End If
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim maRequete As String If Filtre1 "" And Filtre2 "" And Filtre3 = "" And Filtre4 = "" And Filtre5 = "" Then marequete = "Select * From TABLE " Else marequete = "Select * From TABLE WHERE" If Filtre1 <> "" Then maRequete += "WHERE Champ1 Like '" & Filtre1 & "' And " If Filtre2 <> "" Then maRequete += "WHERE Champ2 Like '" & Filtre2 & "' And " End If ' Suppression du dernier And, inutile ' (lignes extraites de l'aide de VB = facile à trouver) If maRequete.Trim().EndsWith(" And") Then Dim DernierePosition As Integer = maRequete.LastIndexOf(" And") If DernierePosition >= 0 Then maRequete = maRequete.Substring(0, DernierePosition) End If End If
Dim maRequete As String If Filtre1 "" And Filtre2 "" And Filtre3 = "" And Filtre4 = "" And Filtre5 = "" Then marequete = "Select * From TABLE " Else marequete = "Select * From TABLE WHERE" If Filtre1 <> "" Then maRequete += " Champ1 Like '" & Filtre1 & "' And " If Filtre2 <> "" Then maRequete += " Champ2 Like '" & Filtre2 & "' And " End If ' Suppression du dernier And, inutile ' (lignes extraites de l'aide de VB = facile à trouver) If maRequete.Trim().EndsWith(" And") Then Dim DernierePosition As Integer = maRequete.LastIndexOf(" And") If DernierePosition >= 0 Then maRequete = maRequete.Substring(0, DernierePosition) End If End If
Dim maRequete As String = "Select * From TABLE WHERE " If Filtre1 <> "" Then maRequete += "Champ1 Like '" & Filtre1 & "' And " If Filtre2 <> "" Then maRequete += "Champ2 Like '" & Filtre2 & "' And " (...) ' Suppression du dernier And, inutile ' (lignes extraites de l'aide de VB = facile à trouver) If maRequete.Trim().EndsWith(" And") Then Dim DernierePosition As Integer = maRequete.LastIndexOf(" And") If DernierePosition >= 0 Then maRequete = maRequete.Substring(0, DernierePosition) End If End If If maRequete.Trim().EndsWith(" Where") Then Dim DernierePosition As Integer = maRequete.LastIndexOf(" Where") If DernierePosition >= 0 Then maRequete = maRequete.Substring(0, DernierePosition) End If End If