openaccess/test/source/queries/r_DonneesImport.bas

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