SQL upit ne daje rezultat

pozdrav svima

delphi 7, dbf

Molim Vas ako neko ima zivaca da mi ukaze na slijedeci upit zasto ne daje nikakav rezultat a ne javlja gresku

moj code - sql upit sa parametrom



UpitZad.Close;
UpitZad.SQL.Clear;
UpitZad.SQL.Add('SELECT * FROM Zaduzenje WHERE (AdresaIzvrs = :Adresa) AND (BUlice BETWEEN :eOd AND :eDo) AND (Datum BETWEEN :DatumOd AND :DatumDo)');
UpitZad.ParamByName('Adresa').AsString := QuotedStr(CAdresa.Text);
UpitZad.ParamByName('eOD').AsString := QuotedStr(eOd.Text);
UpitZad.ParamByName('eDo').AsString := QuotedStr(eDo.Text);
UpitZad.ParamByName('DatumOd').AsDateTime := (DatumOD.Date);
UpitZad.ParamByName('DatumDo').AsDateTime := (DatumDo.Date);
ShowMessage(UpitZad.SQL.Text);
UpitZad.Open;
UpitZad.Refresh;

hvala svima na trudu

Ukloni QuotedStr. Ne treba ti da stringove saljes unutar apostrofa kada radis sa parametrima.

Potpis

"There is a theory which states that if ever anybody discovers exactly what the
Universe is for and why it is here, it will instantly disappear and be replaced by
something even more bizarre and inexplicable. There is another theory which states
that this has already happened."
-- Douglas Adams