Hi all
Would someone please know why I cannot retreive the proper records in this
query?Date is no problem but notetype is?

with datamodule1.IBOquery1 do
begin
Close;
Unprepare;
ParamByName('date').asdate := wwDBDateTimePicker1.date;
prepare;
open;
end;
with datamodule1.IBOquery2 do
begin
Close;
Unprepare;
ParamByName('date').asdate := wwDBDateTimePicker2.date;
prepare;
open;
end;

SQL IBOquery1:
select * from notesdata
where notedate = :date
and notetype = 'D'
order by notedate descending, notetime descending

SQL IBOquery2:
select * from notesdata
where notedate = :date
and notetype = 'M'
order by notedate descending, notetime descending

it does retrieve for the proper day but not the notetype, retreives all
notetypes????

Help please
Daniel