Andy, did you find the cure? I'm using TIBOQuery with QR Pro and the WHERE
clause works well with dates, but I have only a starting date, I don't need
a range for now:
WHERE FECHA >= :FECHA
and I get records as expected.

C.

> -----Original Message-----
> From: Andy Samuel [mailto:andysamuel@...]
> Sent: Lunes 12 de Marzo de 2001 5:25
>
> I've made a mistake in my previous email, it's not IB_Query but TIBOQuery
> for use with QuickReport.
> Funny how I've tried both using the <= and >= and also with the BETWEEN
> clause on IB_Query and TIBOQuery and the grids shows some records ! That
> means it works !
> The question was arise since I only change the SQL from 'SELECT * FROM
> SalesCall' to 'SELECT * FROM SalesCall WHERE ......' and putting some
> variable initialization, and the report doesn't work anymore.
> I will check my coding again since I still don't know that cause the
> problem.