1 2 3 4 5 6 7 8 9 10
| AdoQuery1.SQL.Clear;
AdoQuery1.SQL.Add('SELECT D.DOS_ID, D.DOS_EMPR_NOM, D.DOS_EMPR_PRENOM, D.DOS_DATE_PREMIERE_SAISIE, D.ID_ORDER, D.PROVENANCE_PERFEO, ');
AdoQuery1.SQL.Add('D.DOS_RETOUR_PHASE2, D.DOS_DATE_DEBLOCAGE_PHASE3, D.SUP_ID, D.LGT_ID, D.DOS_COMMISION, D.PH1_ID, D.DOS_DATE_PHASE1, ');
AdoQuery1.SQL.Add('L.LGT_ID, L.LGT_STATUT, S.SUP_ID, S.SUP_LIBELLE, P.PH1_STATUT ');
AdoQuery1.SQL.Add('FROM ((DOSSIER as D INNER JOIN LOGEMENT as L ON D.LGT_ID = L.LGT_ID) ');
AdoQuery1.SQL.Add('INNER JOIN SUPPORT AS S ON S.SUP_ID = D.SUP_ID) INNER JOIN PHASE1 AS P ON P.PH1_ID = D.PH1_ID');
AdoQuery1.SQL.Add('WHERE (DOS_DATE_PREMIERE_SAISIE >= :MY_START_Date) ');
AdoQuery1.SQL.Add('AND (DOS_DATE_PREMIERE_SAISIE <= :MY_END_Date) AND (ID_ORDER <> '''') order by DOS_ID');
AdoQuery1.Parameters.ParamByName('MY_START_Date').Value := StrToDate(Edit9.Text); //format date '15/11/2007'
AdoQuery1.Parameters.ParamByName('MY_END_Date').Value := StrToDate(Edit10.Text); //format date '15/11/2007' |
Partager