Probaj sa parametrima, izbegavaj QuotedStr:
Code:
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('SELECT * FROM Tabela');
SQL.Add('WHERE Ime = :IME AND Datum BETWEEN :DATUMOD AND :DATUMDO' );
Parameters.ParamByName('IME').Value:= Edit1.Text;
Parameters.ParamByName('DATUMOD').Value:= DateToStr(DateTimePicker1.Date);
Parameters.ParamByName('DATUMDO').Value:= DateToStr(DateTimePicker2.Date);
Prepared:= true;
Open;
end;
Someone's sitting in the shade today because someone planted a tree a long time ago.