Subject RE: [firebird-support] How write a query with a progressive sum field
Author Leyne, Sean
> > I need add SALDO fields in the result of the query to get a
> > progressive sum of CARICO - SCARICO.
>
> Although not that flexible as an ad-hoc query, but perhaps your particular
> use case can be achieved with a selectable stored procedure ...

A similar solution, one which could support some degree of "ad-hoc'ness" would be EXECUTE BLOCK.

It would follow the same basic approach of the selectable SP, but with the ability to modify some of the logic/grouping.


Sean