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;
If you go out of your mind, do it quietly, so as not to disturb those around you...