> I have a table with fields total1, total 2 , flag .
> I want to sum total1 and total2 all and total1 for flag=true and
> total2 for flag=false . Can I do it in one sql pass using IBO.

I think there are ways - particularly now that Firebird 1 has some new
functions available. However for the sake of clarity I would
implement this via stored procedure. That way you can be completely
clear inside the stored procedure (with comments etc) as to what you
are trying to do, and then select the result from from IBO (either as
an embedded select or as a separate dataset).

--
Geoff Worboys
Telesis Computing