Thank's for the reply.

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.

Warm regards
Andy

----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, March 12, 2001 3:13 PM
Subject: Re: [IBO] Date issue ( again )


> Try
> IB_Query.SQL := 'SELECT * FROM SalesCall WHERE SCDate BETWEEN :dSCFrom
> AND :dSCTO'
>
> Your original solution ought to work, but I guess IB has some problems
with
> there being no spaces between >= and : I think using between is more
> readable, and I hope (though haven't checked) it can improve the plan IB
> chooses.
>
> HTH,
> Set
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>