openaccess/test/source/queries/r_FormDep_1.bas

Operation =1
Option =0
Begin InputTables
    Name ="tbl_ImportRH"
    Name ="r_VehiculePerso"
End
Begin OutputColumns
    Expression ="tbl_ImportRH.CodeAgent"
    Alias ="JourRH"
    Expression ="Day([DateRH])"
    Alias ="MoisRH"
    Expression ="Month([DateRH])"
    Alias ="AnneeRH"
    Expression ="Year([DateRH])"
    Expression ="tbl_ImportRH.Localisation"
    Expression ="tbl_ImportRH.DistanceTranche1"
    Expression ="tbl_ImportRH.VehiculePersoTranche1"
    Alias ="Distance1_perso"
    Expression ="[DistanceTranche1]*IIf([VehiculePersoTranche1]='true',1,0)"
    Expression ="tbl_ImportRH.DistanceTranche2"
    Expression ="tbl_ImportRH.VehiculePersoTranche2"
    Alias ="Distance2_perso"
    Expression ="[DistanceTranche2]*IIf([VehiculePersoTranche2]='true',1,0)"
    Alias ="Distance2_service"
    Expression ="[DistanceTranche2]*IIf([VehiculePersoTranche2]='true',0,1)"
    Expression ="tbl_ImportRH.Repas"
    Expression ="tbl_ImportRH.Remarque"
    Expression ="r_VehiculePerso.TypeVehicule"
End
Begin Joins
    LeftTable ="r_VehiculePerso"
    RightTable ="tbl_ImportRH"
    Expression ="r_VehiculePerso.CodeAgent = tbl_ImportRH.CodeAgent"
    Flag =3
End
Begin OrderBy
    Expression ="tbl_ImportRH.CodeAgent"
    Flag =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="-1"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbBoolean "FilterOnLoad" ="0"
dbBoolean "OrderByOnLoad" ="-1"
dbBoolean "TotalsRow" ="0"
dbMemo "OrderBy" ="[r_FormDep_1].[AnneeRH] DESC, [r_FormDep_1].[MoisRH] DESC"
Begin
    Begin
        dbText "Name" ="tbl_ImportRH.CodeAgent"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_ImportRH.VehiculePersoTranche1"
        dbLong "AggregateType" ="-1"
        dbInteger "ColumnWidth" ="3015"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_ImportRH.DistanceTranche2"
        dbLong "AggregateType" ="-1"
        dbInteger "ColumnWidth" ="2055"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_ImportRH.DistanceTranche1"
        dbLong "AggregateType" ="-1"
        dbInteger "ColumnWidth" ="2850"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="MoisRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="JourRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="AnneeRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_ImportRH.Remarque"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_ImportRH.VehiculePersoTranche2"
        dbLong "AggregateType" ="-1"
        dbInteger "ColumnWidth" ="2325"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_ImportRH.Repas"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="Distance1_perso"
        dbLong "AggregateType" ="-1"
        dbInteger "ColumnWidth" ="1950"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Distance2_perso"
        dbLong "AggregateType" ="-1"
        dbInteger "ColumnWidth" ="2355"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Distance2_service"
        dbLong "AggregateType" ="-1"
        dbInteger "ColumnWidth" ="2325"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_ImportRH.Localisation"
        dbInteger "ColumnWidth" ="5160"
        dbBoolean "ColumnHidden" ="0"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="r_VehiculePerso.TypeVehicule"
        dbLong "AggregateType" ="-1"
    End
End
Begin
    State =0
    Left =0
    Top =0
    Right =1099
    Bottom =840
    Left =-1
    Top =-1
    Right =677
    Bottom =229
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =48
        Top =12
        Right =253
        Bottom =240
        Top =0
        Name ="tbl_ImportRH"
        Name =""
    End
    Begin
        Left =301
        Top =12
        Right =510
        Bottom =185
        Top =0
        Name ="r_VehiculePerso"
        Name =""
    End
End