[ cojaa @ 24.02.2007. 10:09 ] @

Postavio sam upit ovako...

close;
adoquery2.SQL.Clear;
adoquery2.SQL.Add('select x,count(*)as ukupno from podaci');
adoquery2.SQL.Add('where ime = ' + quotedstr(cb1.Text) + 'and datum between date' + quotedstr(datetostr(jvdatetimepicker1.Date)) + 'and date' + quotedstr(datetostr(jvdatetimepicker2.Date)) + 'group by x order by count(*) desc');
open;

Javlja mi gresku

Syntax error (missing operator) in query expression 'Ime='Pero''and datum
between date'24.2.2007'and date'25.2.2007''

Ovako mi je radilo sa queryjem iz bde ali sa adoquery nece.Hvala unapred.
[ Miloš Baić @ 24.02.2007. 10:29 ] @
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;
[ cojaa @ 24.02.2007. 11:00 ] @
To je to. Hvala ti puno...