openaccess/test/source/queries/r_FormDep_1Somme.bas

Operation =1
Option =0
Begin InputTables
    Name ="r_FormDep_1"
End
Begin OutputColumns
    Expression ="r_FormDep_1.AnneeRH"
    Expression ="r_FormDep_1.MoisRH"
    Expression ="r_FormDep_1.CodeAgent"
    Expression ="r_FormDep_1.JourRH"
    Alias ="SommeDeDistance1_perso"
    Expression ="Sum(r_FormDep_1.Distance1_perso)"
    Alias ="SommeDeDistance2_perso"
    Expression ="Sum(r_FormDep_1.Distance2_perso)"
    Alias ="SommeDeDistance2_service"
    Expression ="Sum(r_FormDep_1.Distance2_service)"
    Alias ="SommeDeRepas"
    Expression ="Sum(r_FormDep_1.Repas)"
    Alias ="Itineraire"
    Expression ="Itineraire('r_FormDep_1','Localisation',[CodeAgent],[JourRH],[MoisRH],[anneeRH])"
End
Begin OrderBy
    Expression ="r_FormDep_1.AnneeRH"
    Flag =0
    Expression ="r_FormDep_1.MoisRH"
    Flag =0
    Expression ="r_FormDep_1.CodeAgent"
    Flag =0
    Expression ="r_FormDep_1.JourRH"
    Flag =0
End
Begin Groups
    Expression ="r_FormDep_1.AnneeRH"
    GroupLevel =0
    Expression ="r_FormDep_1.MoisRH"
    GroupLevel =0
    Expression ="r_FormDep_1.CodeAgent"
    GroupLevel =0
    Expression ="r_FormDep_1.JourRH"
    GroupLevel =0
End
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"
dbBoolean "UseTransaction" ="-1"
Begin
    Begin
        dbText "Name" ="r_FormDep_1.JourRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="SommeDeDistance1_perso"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="SommeDeDistance2_perso"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="SommeDeDistance2_service"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="SommeDeRepas"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FormDep_1.CodeAgent"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FormDep_1.MoisRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FormDep_1.AnneeRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="Itineraire"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="AnneeRH"
    End
    Begin
        dbText "Name" ="MoisRH"
    End
    Begin
        dbText "Name" ="JourRH"
    End
End
Begin
    State =0
    Left =0
    Top =0
    Right =1039
    Bottom =840
    Left =-1
    Top =-1
    Right =1023
    Bottom =160
    Left =0
    Top =0
    ColumnsShown =543
    Begin
        Left =48
        Top =12
        Right =192
        Bottom =156
        Top =0
        Name ="r_FormDep_1"
        Name =""
    End
End