Totaling record items in a multi-record detail block
Posted on 1998-04-03
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?