Re: Sum of Details on Master

Dmitry L. Zhuk wrote:
>
> Michael Ho wrote:
> >
> > eg. You can try a non-based-table item in Master Block and do a summary
> > on POST_QUERY
> >
> > In design point of view, table definition should be your last area to
> > touch for screen design.
>
> You can't summary in POST-QUERY trigger, because you form may fetch into
> buffers only fixed number of records (see Record Buffered, Record
> Fetched properties for you block), and you trigger count only this
> records.
> You can use POST-SELECT trigger to calc you formula (sums or others)
> with :System.Last_Query variable. If you want see only count of raws in
> detail block, you can use ON-COUNT trigger & value of Count_Query
> build-in.

Assuming you are try to use the Master-Detail Blocks, the Post-Query trigger can issue a select query against the database for data.

Or assuming you are using only one master record, with multiple detail, You can simple issue a select query after the execute_query.

Summary using POST-Query trigger is also possible if you don't mind fetching all records.

Regards,
Michael Received on Wed Apr 09 1997 - 00:00:00 CDT