openaccess/test/source/queries/r_SyntheseRH_DisTr1.bas

Operation =6
Option =0
Begin InputTables
    Name ="r_DonneesImport"
End
Begin OutputColumns
    Expression ="r_DonneesImport.AnneeRH"
    GroupLevel =2
    Expression ="r_DonneesImport.MoisRH"
    GroupLevel =2
    Expression ="r_DonneesImport.CodeAgent"
    GroupLevel =2
    Expression ="r_DonneesImport.VehiculePersoTranche1"
    GroupLevel =1
    Alias ="SommeDeDistanceTranche1"
    Expression ="Sum(r_DonneesImport.DistanceTranche1)"
End
Begin OrderBy
    Expression ="r_DonneesImport.AnneeRH"
    Flag =0
    Expression ="r_DonneesImport.MoisRH"
    Flag =0
End
Begin Groups
    Expression ="r_DonneesImport.AnneeRH"
    GroupLevel =2
    Expression ="r_DonneesImport.MoisRH"
    GroupLevel =2
    Expression ="r_DonneesImport.CodeAgent"
    GroupLevel =2
    Expression ="r_DonneesImport.VehiculePersoTranche1"
    GroupLevel =1
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="r_SyntheseRH_inter.anneeRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_SyntheseRH_inter.VehiculePersoTranche2"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_SyntheseRH_inter.VehiculePersoTranche1"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_SyntheseRH_inter.CodeAgent"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_SyntheseRH_inter.moisRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_SyntheseRH_inter.SommeDeDistanceTranche2"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_SyntheseRH_inter.SommeDeDistanceTranche1"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="PIVOT"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="SommeDeSommeDeDistanceTranche2"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="False"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="True"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="SommeDeSommeDeDistanceTranche1"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="AnneeRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_DonneesImport.VehiculePersoTranche1"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="SommeDeDistanceTranche2"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="MoisRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="SommeDeDistanceTranche1"
    End
    Begin
        dbText "Name" ="Expr1"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_DonneesImport.AnneeRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_DonneesImport.MoisRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_DonneesImport.CodeAgent"
        dbLong "AggregateType" ="-1"
    End
End
Begin
    State =0
    Left =0
    Top =0
    Right =833
    Bottom =545
    Left =-1
    Top =-1
    Right =817
    Bottom =203
    Left =0
    Top =0
    ColumnsShown =559
    Begin
        Left =48
        Top =12
        Right =192
        Bottom =156
        Top =0
        Name ="r_DonneesImport"
        Name =""
    End
End