var DT,DTB,ATT : string; begin DT := QuotedStr(DateToStr(Date)); DTB:= QuotedStr(DateToStr(StrToDate('13/03/2000')); ATT:= QuotedStr(ComboBox3.Text); query1.SQL.Clear; query1.SQL.Add('SELECT name, surname, worktype, desc '); query1.SQL.Add('FROM people, affectation, activities, places '); query1.SQL.Add('WHERE (people.ID=affectation.IDPeople) '); query1.SQL.Add('AND (affectation.IDActivity=activities.ID) '); query1.SQL.Add('AND (affectation.IDPlace=places.ID) '); query1.SQL.Add('AND (activities.title='+ATT+') '); query1.SQL.Add('AND (affect.date BETWEEN '+DTB+' AND '+DT+');');
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question