--- In IBObjects@y..., "duilio_fos" <irel_llc@l...> wrote:

after a lot of head scratching, I have found the culprit.

It seems that writing

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');

is ok.

Thank you

Duilio Foschi