1 2 3 4 5 6 7 8 9 10 11 12 13
| Private Sub AfficherLot(ByVal Ligne As Integer, ByVal Fin As Integer)
rsListView = " SELECT * FROM (" & _
" SELECT TOP " & nbLigne & " NumVehicule as Vehicule,Immatriculation, Depot as Dépôt, TypeVehicule as 'Type véhicule',NumChassis as 'Numéro chassis', NomPArc as 'Parc' FROM ( " & _
" SELECT TOP " & numFin & " NumVehicule,Immatriculation, T_Depot.Depot, T_TypeVehicule.TypeVehicule,NumChassis, NomPArc FROM T_Vehicule,T_Depot,T_TypeVehicule,T_Parc " & _
" WHERE T_Vehicule.idTypeVehicule = T_TypeVehicule.idTypeVehicule and T_Vehicule.idDepot = T_Depot.idDepot AND T_Parc.idParc = T_Vehicule.idParc " & strFiltre & " " & _
" ORDER BY NumVehicule ASC " & _
" ) AS tbl1 ORDER BY NumVehicule DESC " & _
" ) AS tbl2 ORDER BY Vehicule DESC "
If OuvertureConnexion(objConnexion, chConnexion) Then
FormaterListView objConnexion, rsListView, lstVehicule
FermetureConnexion objConnexion
End If
End Sub |
Partager