openaccess/test/source/queries/r_ExportPDE_PERIPLE.bas

dbMemo "SQL" ="INSERT INTO PDE_PERIPLE ( IDF_AGENT, DATE_DEMANDE, MOTIF_DEPLACEMENT, ITINERAIRE"
    ", CP_DEP, DATE_DEPART, DATE_RETOUR, MOYEN_TRANSPORT, NB_KM_PARCOURUS, NBR_REPAS_"
    "PLEIN )\015\012SELECT tbl_Agents.Matricule AS IDF_AGENT, Date() AS DATE_DEMANDE,"
    " 'Travaux chantier' AS MOTIF_DEPLACEMENT, 'ERSTEIN-' & [LOCALISATION] AS ITINERA"
    "IRE, Left([CodeLocalisation],5) AS CP_DEP, CDate(CStr([DateRH]) & ' 07:30') AS D"
    "ATE_DEPART, CDate(CStr([DateRH]) & ' 07:30') AS DATE_RETOUR, IIf([VehiculePersoT"
    "ranche1]='True' or [VehiculePersoTranche2]='True','Véhicule personnel','Véhicule"
    " de service') AS MOYEN_TRANSPORT, (IIf([VehiculePersoTranche1]='True',[DistanceT"
    "ranche1],0)+IIf([VehiculePersoTranche2]='True',[DistanceTranche2],0)) AS NB_KM_P"
    "ARCOURUS, tbl_ImportRH.Repas AS NBR_REPAS_PLEIN\015\012FROM tbl_ImportRH INNER J"
    "OIN tbl_Agents ON tbl_ImportRH.CodeAgent = tbl_Agents.CodeAgent;\015\012"
dbMemo "Connect" =""
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_ImportRH.CodeAgent"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.CodeAgent"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.TypeVehicule"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_ImportRH.VehiculePersoTranche1"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="Expr1"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="DATE_DEMANDE"
        dbText "Format" ="dd/mm/yyyy"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_Agents.Matricule"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="IDF_AGENT"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="MOTIF_DEPLACEMENT"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="ITINERAIRE"
        dbInteger "ColumnWidth" ="2970"
        dbBoolean "ColumnHidden" ="0"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="CP_DEP"
        dbInteger "ColumnWidth" ="1125"
        dbBoolean "ColumnHidden" ="0"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="DATE_DEPART"
        dbInteger "ColumnWidth" ="1995"
        dbBoolean "ColumnHidden" ="0"
        dbText "Format" ="dd/mm/yyyy hh:nn"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="MOYEN_TRANSPORT"
        dbLong "AggregateType" ="-1"
        dbInteger "ColumnWidth" ="2325"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="NB_KM_PARCOURUS"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_ImportRH.Repas"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="NBR_REPAS_PLEIN"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="DATE_RETOUR"
        dbInteger "ColumnWidth" ="1995"
        dbBoolean "ColumnHidden" ="0"
        dbText "Format" ="dd/mm/yyyy hh:nn"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="tbl_ImportRH.DateRH"
        dbLong "AggregateType" ="-1"
    End
    Begin
        dbText "Name" ="Expr2"
        dbLong "AggregateType" ="-1"
    End
End