Re: Forms 4.5: Problems displaying totals based on query

If the block is a base table block then use the POST-QUERY trigger. This fires for each record fetched from the database.

    :sum_block.suma := :mutli_block.valuea + :sum_block.suma;

NOTE: clear value in :sum_block.suma when first start form (WHEN-NEW-FORM-INSTANCE) and each time user requeries (KEY-EXEQRY).

If not a base table block then total while executing your cursor.

  HOPE THIS does the trick.

Gerardo Quián <gquian_at_gapd.es> wrote in article <34473812.DA2E5D68_at_gapd.es>...
> Hi All,
>
> I think this is an easy question.
>
> After a query on a multi-record block I'd like to show the sum for a
> column into a display item. Is there a simple way to do this?
>
> Thank you all.
>
>
Received on Fri Oct 24 1997 - 00:00:00 CEST