openaccess/test/source/queries/r_Agents.bas

Operation =1
Option =0
Begin InputTables
    Name ="r_AgentValide"
    Name ="tbl_Agents"
End
Begin OutputColumns
    Expression ="tbl_Agents.CodeAgent"
    Expression ="tbl_Agents.Nom"
    Expression ="tbl_Agents.Grade"
    Expression ="tbl_Agents.Catégorie"
    Expression ="tbl_Agents.RémunérationBase"
    Expression ="tbl_Agents.Groupe"
    Expression ="tbl_Agents.ResidenceAdmin"
    Expression ="tbl_Agents.ResidenceFamiliale"
    Expression ="tbl_Agents.Telephone"
    Expression ="tbl_Agents.Matricule"
    Expression ="tbl_Agents.TypeVehicule"
    Expression ="tbl_Agents.DateAutorisationVP"
    Expression ="tbl_Agents.PuissanceFiscVP"
    Expression ="tbl_Agents.NbKmAutorisesVP"
    Expression ="tbl_Agents.TypeVirement"
    Expression ="tbl_Agents.PeriodeValidite"
End
Begin Joins
    LeftTable ="r_AgentValide"
    RightTable ="tbl_Agents"
    Expression ="r_AgentValide.Expr1 = tbl_Agents.PeriodeValidite"
    Flag =1
    LeftTable ="r_AgentValide"
    RightTable ="tbl_Agents"
    Expression ="r_AgentValide.CodeAgent = tbl_Agents.CodeAgent"
    Flag =1
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_Agents.PeriodeValidite"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.CodeAgent"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.Nom"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.Grade"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.Catégorie"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.RémunérationBase"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.Groupe"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.ResidenceAdmin"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.ResidenceFamiliale"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.Telephone"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.Matricule"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.TypeVehicule"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.DateAutorisationVP"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.PuissanceFiscVP"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.NbKmAutorisesVP"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.TypeVirement"
        dbLong "AggregateType" ="-1"
    End
End
Begin
    State =0
    Left =0
    Top =0
    Right =1072
    Bottom =840
    Left =-1
    Top =-1
    Right =1056
    Bottom =460
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =268
        Top =12
        Right =412
        Bottom =156
        Top =0
        Name ="r_AgentValide"
        Name =""
    End
    Begin
        Left =35
        Top =12
        Right =207
        Bottom =376
        Top =0
        Name ="tbl_Agents"
        Name =""
    End
End