Subject | Re: [IBO] Re: debugging queries |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2002-09-23T13:11:37Z |
Duilio,
At 14:27 22.09.2002 +0000, you wrote:
ADate-1 rather than ADate+1.
Set
At 14:27 22.09.2002 +0000, you wrote:
>q.SQL.Add('select * from ATable');these two statements are actually different. I guess what you want is
>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');
ADate-1 rather than ADate+1.
Set