Voici,
Est-ce qu'il existe une restriction concernant le nombre de caracteres que l'on peut associer a une STRING? Je pensais que l'on pouvais mettre 2Exp16 caracteres mais si je met la string suivante, l'editeur de code ne le permet pas....
Code SQL : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5 SELECT Count(Priority.group) AS GroupCount, Priority.group FROM Trips INNER JOIN Priority ON Trips.purpose = Priority.priorityName WHERE (((Trips.status)='Approved' Or (Trips.status)='Flown' Or (Trips.status)='Completed') AND ((Year([dateDep]))=Year(Now())) AND ((Trips.aircraftCommander)='" & crew & "') AND ((Priority.group)='student')) OR (((Trips.status)='Approved' Or (Trips.status)='Flown' Or (Trips.status)='Completed') AND ((Year([dateDep]))=Year(Now())) AND ((Trips.aircraftCommander)='" & crew & "') AND ((Priority.group)='XCtry')) OR (((Trips.status)='Approved' Or (Trips.status)='Flown' Or (Trips.status)='Completed') AND ((Year([dateDep]))=Year(Now())) AND ((Trips.aircraftCommander)='" & crew & "') AND ((Priority.group)='o&b')) OR (((Trips.status)='Approved' Or (Trips.status)='Flown' Or (Trips.status)='Completed') AND ((Year([dateDep]))=Year(Now())) AND ((Priority.group)='student') AND ((Trips.pax)='" & crew & "')) OR (((Trips.status)='Approved' Or (Trips.status)='Flown' Or (Trips.status)='Completed') AND ((Year([dateDep]))=Year(Now())) AND ((Priority.group)='XCtry') AND ((Trips.pax)='" & crew & "')) OR (((Trips.status)='Approved' Or (Trips.status)='Flown' Or (Trips.status)='Completed') AND ((Year([dateDep]))=Year(Now())) AND ((Priority.group)='o&b') AND ((Trips.pax)='" & crew & "')) GROUP BY Priority.group ORDER BY Priority.group;
Acheo
Partager