openaccess/test/source/queries/r_FraisKm3.bas

Operation =1
Option =0
Begin InputTables
    Name ="r_FraisKm2"
    Name ="tbl_baremes"
End
Begin OutputColumns
    Expression ="r_FraisKm2.CodeAgent"
    Expression ="r_FraisKm2.AnneeRH"
    Expression ="r_FraisKm2.MoisRH"
    Expression ="r_FraisKm2.TypeVehicule"
    Expression ="tbl_baremes.Commentaire"
    Expression ="tbl_baremes.NomBareme"
    Expression ="r_FraisKm2.PeriodeBareme"
    Expression ="tbl_baremes.BorneInf"
    Expression ="tbl_baremes.BorneSup"
    Expression ="tbl_baremes.UniteBornes"
    Expression ="tbl_baremes.Valeur"
    Expression ="tbl_baremes.UniteValeur"
    Expression ="r_FraisKm2.DistanceAnnee"
    Expression ="r_FraisKm2.DistanceMois"
    Alias ="DistanceAnneeRepartie"
    Expression ="IIf([DistanceAnnee]>[BorneSup],([BorneSup]-[BorneInf]),IIf([DistanceAnnee]>[Born"
        "eInf],[DistanceAnnee]-[BorneInf],0))"
    Alias ="DistanceMoisRepartie"
    Expression ="IIf(([DistanceAnnee]+[DistanceMois])>[BorneSup],([BorneSup]-[BorneInf]),IIf(([Di"
        "stanceAnnee]+[DistanceMois])>[BorneInf],([DistanceAnnee]+[DistanceMois])-[BorneI"
        "nf],0))-[DistanceAnneeRepartie]"
    Alias ="Montant"
    Expression ="CCur([DistanceMoisRepartie]*[Valeur])"
End
Begin Joins
    LeftTable ="r_FraisKm2"
    RightTable ="tbl_baremes"
    Expression ="r_FraisKm2.BaremeUtilise = tbl_baremes.NomBareme"
    Flag =1
    LeftTable ="r_FraisKm2"
    RightTable ="tbl_baremes"
    Expression ="r_FraisKm2.PeriodeBareme = tbl_baremes.PeriodeValidite"
    Flag =1
End
Begin OrderBy
    Expression ="r_FraisKm2.CodeAgent"
    Flag =0
    Expression ="r_FraisKm2.AnneeRH"
    Flag =0
    Expression ="r_FraisKm2.MoisRH"
    Flag =0
    Expression ="tbl_baremes.NomBareme"
    Flag =0
    Expression ="tbl_baremes.BorneInf"
    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" ="tbl_baremes.Commentaire"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_baremes.NomBareme"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_baremes.BorneInf"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FraisKm2.DistanceMois"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_baremes.BorneSup"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_baremes.UniteBornes"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_baremes.Valeur"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_baremes.UniteValeur"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FraisKm2.CodeAgent"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FraisKm2.MoisRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FraisKm2.AnneeRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FraisKm2.DistanceAnnee"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="DistanceAnneeRepartie"
        dbInteger "ColumnWidth" ="2340"
        dbBoolean "ColumnHidden" ="0"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="DistanceMoisRepartie"
        dbLong "AggregateType" ="-1"
        dbInteger "ColumnWidth" ="2715"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Montant"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FraisKm2.PeriodeBareme"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FraisKm2.TypeVehicule"
        dbLong "AggregateType" ="-1"
    End
End
Begin
    State =0
    Left =0
    Top =0
    Right =1125
    Bottom =545
    Left =-1
    Top =-1
    Right =1109
    Bottom =53
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =48
        Top =12
        Right =207
        Bottom =200
        Top =0
        Name ="r_FraisKm2"
        Name =""
    End
    Begin
        Left =372
        Top =9
        Right =608
        Bottom =192
        Top =0
        Name ="tbl_baremes"
        Name =""
    End
End