openaccess/test/source/queries/r_FraisKm2.bas

Operation =1
Option =0
Begin InputTables
    Name ="r_FraisKm1"
End
Begin OutputColumns
    Expression ="r_FraisKm1.CodeAgent"
    Expression ="r_FraisKm1.MoisRH"
    Expression ="r_FraisKm1.AnneeRH"
    Expression ="r_FraisKm1.TypeVehicule"
    Alias ="DistanceAnnee"
    Expression ="DistanceAnnee([CodeAgent],[MoisRH],[AnneeRH])"
    Expression ="r_FraisKm1.DistanceMois"
    Expression ="r_FraisKm1.BaremeUtilise"
    Alias ="PeriodeBareme"
    Expression ="CInt(PeriodeBareme([BaremeUtilise],[MoisRH],[AnneeRH]))"
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" ="r_FraisKm1.AnneeRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FraisKm1.CodeAgent"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FraisKm1.MoisRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FraisKm1.TypeVehicule"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FraisKm1.BaremeUtilise"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="PeriodeBareme"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_FraisKm1.DistanceMois"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="DistanceAnnee"
        dbLong "AggregateType" ="-1"
    End
End
Begin
    State =0
    Left =0
    Top =0
    Right =1125
    Bottom =545
    Left =-1
    Top =-1
    Right =1109
    Bottom =43
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =48
        Top =12
        Right =297
        Bottom =211
        Top =0
        Name ="r_FraisKm1"
        Name =""
    End
End