Solved

Totaling record items in a multi-record detail block

Posted on 1998-04-03
2
618 Views
Last Modified: 2012-05-05
1.)  When Oracle Forms returns rows for a multi-record base table block, will looping through the records in the block read all rows in the originating cursor or only the rows fetched into the block.
ie: multi-record block, items displayed = 4
                        items buffered = 7
                        rows = 500 in database
So, if I want to total a column in all rows, would it be correct to loop through the block or query the database?
0
Comment
Question by:dawson011398
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
yesnaud earned 50 total points
ID: 1082986
Hi,

Oracle form is crap at retrieving the number of record a query might fetch. But I wouldn't recommended looping thru the block to get a total. (more network traffic, slow down the client / server). What I would do is to total a column in a separate query in a procedure I would create in program units. That will improve radically the speed (well still depends how much records you have, and if there is a lot it might be a good idea to have a index on the where clause you are using to sum the column...)

Yoann.
0
 

Author Comment

by:dawson011398
ID: 1082987
Thanks for the help, it was greatly appreciated.  I was thinking about doing the totals in a program unit procedure, you have just  convinced me to do that.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question