openaccess/test/source/queries/r_HeuresSup.bas

Operation =1
Option =0
Begin InputTables
    Name ="tbl_FormDep"
    Name ="r_DonneesImport2"
End
Begin OutputColumns
    Expression ="r_DonneesImport2.CodeAgent"
    Expression ="r_DonneesImport2.DateRH"
    Expression ="r_DonneesImport2.JourRH"
    Expression ="r_DonneesImport2.MoisRH"
    Expression ="r_DonneesImport2.AnneeRH"
    Alias ="HeureSup1"
    Expression ="r_DonneesImport2.SommeDeHeureSup1"
    Expression ="tbl_FormDep.HeuresDep"
    Alias ="HeureSup2"
    Expression ="r_DonneesImport2.SommeDeHeureSup2"
    Expression ="tbl_FormDep.HeuresDepNuit"
    Alias ="HS"
    Expression ="Nz([SommeDeHeureSup1]+[HeuresDep],0)"
    Alias ="HSNuit"
    Expression ="Nz([SommeDeHeureSup2]+[HeuresDepNuit],0)"
    Alias ="HeureSupDimanche"
    Expression ="r_DonneesImport2.SommeDeHeureSupDimanche"
    Alias ="HS_VHCanal"
    Expression ="r_DonneesImport2.SommeDeHS_VHCanal"
    Alias ="HS_Chantier"
    Expression ="r_DonneesImport2.SommeDeHS_Chantier"
End
Begin Joins
    LeftTable ="tbl_FormDep"
    RightTable ="r_DonneesImport2"
    Expression ="tbl_FormDep.CodeAgent = r_DonneesImport2.CodeAgent"
    Flag =1
    LeftTable ="tbl_FormDep"
    RightTable ="r_DonneesImport2"
    Expression ="tbl_FormDep.AnneeRH = r_DonneesImport2.AnneeRH"
    Flag =1
    LeftTable ="tbl_FormDep"
    RightTable ="r_DonneesImport2"
    Expression ="tbl_FormDep.MoisRH = r_DonneesImport2.MoisRH"
    Flag =1
    LeftTable ="tbl_FormDep"
    RightTable ="r_DonneesImport2"
    Expression ="tbl_FormDep.JourRH = r_DonneesImport2.JourRH"
    Flag =1
End
Begin OrderBy
    Expression ="r_DonneesImport2.CodeAgent"
    Flag =0
    Expression ="r_DonneesImport2.JourRH"
    Flag =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"
Begin
    Begin
        dbText "Name" ="HS"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="HSNuit"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_FormDep.HeuresDep"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_FormDep.HeuresDepNuit"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="HeureSup1"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="HeureSup2"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="HeureSupDimanche"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_DonneesImport2.CodeAgent"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_DonneesImport2.JourRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_DonneesImport2.MoisRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_DonneesImport2.AnneeRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_DonneesImport2.DateRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="Expr1"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="HS_VHCanal"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_DonneesImport2.SommeDeHS_Chantier"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="HS_Chantier"
        dbLong "AggregateType" ="-1"
    End
End
Begin
    State =0
    Left =0
    Top =0
    Right =797
    Bottom =545
    Left =-1
    Top =-1
    Right =781
    Bottom =308
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =339
        Top =12
        Right =579
        Bottom =344
        Top =0
        Name ="tbl_FormDep"
        Name =""
    End
    Begin
        Left =48
        Top =12
        Right =262
        Bottom =254
        Top =0
        Name ="r_DonneesImport2"
        Name =""
    End
End