dbMemo "SQL" ="SELECT tbl_ImportRH.IdImportRH, tbl_ImportRH.CodeLigne, tbl_ImportRH.CodeAgent, " "tbl_ImportRH.DateRH, tbl_ImportRH.CodeChantier, tbl_ImportRH.CodeLocalisation, t" "bl_ImportRH.Localisation, tbl_ImportRH.HeureSup1, tbl_ImportRH.HeureSup2, tbl_Im" "portRH.HeureSupDimanche, tbl_ImportRH.Repas, tbl_ImportRH.DistanceTranche1, tbl_" "ImportRH.VehiculePersoTranche1, tbl_ImportRH.DistanceTranche2, tbl_ImportRH.Vehi" "culePersoTranche2, tbl_ImportRH.Remarque, Month([DateRH]) AS MoisRH, Year([dateR" "H]) AS AnneeRH, Day([DateRH]) AS JourRH, IIf([strCategorieInterventionId]=\"07\"" ",(CSng([HeureSup1])+CSng([HeureSup2])+CSng([HeureSupDimanche])),0) AS HS_VHCanal" ", tbl_ImportRH.strCategorieInterventionId, IIf([strCategorieInterventionId]=\"07" "\",0,(CSng([HeureSup1])+CSng([HeureSup2])+CSng([HeureSupDimanche]))) AS HS_Chant" "ier, (Not ((CInt([Repas])>0 Or (IIf([VehiculePersoTranche1]='True',CLng([Distanc" "eTranche1]),0)+IIf([VehiculePersoTranche2]='True',CLng([DistanceTranche2]),0)>0)" ") And (Nz([Localisation],'')=Nz([ResidenceAdmin],'')))) AS FraisValide\015\012FR" "OM tbl_ImportRH INNER JOIN tbl_Agents ON tbl_ImportRH.CodeAgent = tbl_Agents.Cod" "eAgent\015\012ORDER BY tbl_ImportRH.IdImportRH DESC;\015\012" dbMemo "Connect" ="" dbBoolean "ReturnsRecords" ="-1" dbInteger "ODBCTimeout" ="60" dbByte "RecordsetType" ="0" dbBoolean "OrderByOn" ="0" dbByte "Orientation" ="0" dbByte "DefaultView" ="2" dbBoolean "FilterOnLoad" ="0" dbBoolean "OrderByOnLoad" ="-1" dbBoolean "TotalsRow" ="0" Begin Begin dbText "Name" ="tbl_ImportRH.VehiculePersoTranche2" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.HeureSup1" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.HeureSup2" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.HeureSupDimanche" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.Repas" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.DistanceTranche1" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.VehiculePersoTranche1" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.DistanceTranche2" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.Localisation" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="MoisRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="AnneeRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.IdImportRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.Remarque" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="JourRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.CodeLigne" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.CodeAgent" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.DateRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.CodeChantier" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.CodeLocalisation" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="HS_VHCanal" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="HS_Chantier" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_ImportRH.strCategorieInterventionId" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="FraisValide" dbLong "AggregateType" ="-1" End End