Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to show the column total in a multi-record block?

How to show the column total in a multi-record block?

From: <brandonho_at_rocketmail.com>
Date: 1997/03/23
Message-ID: <859178066.32687@dejanews.com>#1/1

  1. How to create "total" item for each column in a multi-record block so that whenever a value changed in any cell, its associated column total will be updated. The column total is equal to the sum of all values in that column whether not is currently being displayed.
  2. How can I update all values in a column of a multi-record block? For example, a multi-record block contains two columns which are Column_A and Column_B. And Column_B := Column_A * Factor. Where Factor is a data entry field which user can be changed anytime. Therefor Column_B should be updated whenever user change the value in Factor.

Any help would be appreciated.

Thanks,
Brandon Ho
(Environment: Forms 4.5, Oracle 7.2, Windows 3.11, Novell Netware)

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Sun Mar 23 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US