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