1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| req est une chaine
req = "Select AdresseP.NoPre AS NoPre,
AdresseP.NomClas AS NomClas,
AdresseP.NomPhon AS NomPhon,
AdresseP.Prenom AS Prenom,
AdresseP.CPost AS CPost,
FROM AdresseP
JOIN (
Select NomClas,CPost,NomPhon from AdresseP
Group by NomClas,CPost,NomPhon
Having count(*) > 1) AS Dbl
On "
temp est une chaine
Si INTERR1[1]=1 ALORS temp = "AdresseP .NomClas = Dbl.NomClas"
Si INTERR1[2]=1 ALORS temp += "AND AdresseP .NomPhon = Dbl.NomPhon"
Si INTERR1[3]=1 ALORS temp += "AND AdresseP .CPost = Dbl.CPost"
SI gauche(temp,4) = "AND " ALORS
temp = droite(temp,taille(temp) - 4)
req += temp + " ORDER BY NomClas,CPost,NomPhon" |
Partager