1 2 3 4 5 6 7 8 9
| QClassement->Close() ;
QClassement->SQL->Clear() ;
QClassement->SQL->Add("SELECT DISTINCT CDate(Appels_tbl.date_relance), Appels_tbl.date_relance, Appels_tbl.id, Clients_tbl.id, Clients_tbl.Nom, Clients_tbl.Prenom, Clients_tbl.rue, Clients_tbl.code_postal, Clients_tbl.ville, Clients_tbl.fixe, Clients_tbl.portable, Clients_tbl.mail ");
QClassement->SQL->Add("FROM Appels_tbl, clients_tbl ") ;
QClassement->SQL->Add("WHERE Appels_tbl.id = Clients_tbl.id ") ;
QClassement->SQL->Add("AND Appels_tbl.date_relance NOT IN ('') "); // "AND Appels_tbl.date_relance is not null" ?????
QClassement->SQL->Add("ORDER BY CDate(Appels_tbl.date_relance) DESC ");
QClassement->ExecSQL() ;
QClassement->Open() ; |