Subject Re: [IBO] Re: debugging queries
Author Svein Erling Tysvaer
Duilio,

At 14:27 22.09.2002 +0000, you wrote:
>q.SQL.Add('select * from ATable');
>q.SQL.Add('where');
>q.SQL.Add('ADate=:date+1');
>
>is bad.
>
>Instead, writing
>
>q.SQL.Add('select * from ATable');
>q.SQL.Add('where');
>q.SQL.Add('ADate+1=:date');

these two statements are actually different. I guess what you want is
ADate-1 rather than ADate+1.

Set