21-04-2014, 04:46 PM
كود :
function access_date(const S: string): string;
begin
Result := '#' + S + '#'
end;كود :
d1:=DateToStr(DateTimePicker1.Date);
d2:=DateToStr(DateTimePicker2.Date);
suc:='1ere modl';
col:='vert';
ADOStoredProc1.Filter:='DATE >= '+access_date(d2)+' and SUCRE LIKE '+QuotedStr(suc+'')+''' and Couleur LIKE '+QuotedStr(col+'')+' and DATE <= '+access_date(d1)+' ';
ADOStoredProc1.Filtered:=true;
