Page formatting and numbering

Recently, my project has decided to convert all reports being generated in Developer/2000 into Pro*C programs that generate the same information.
Generally speaking, converting the application has not been too bad, but we have come across a stumbling block and I was wondering if someone in any of the groups could provide some advise or where to purchase utilities
for doing the following:

The programmers converting the Developer/2000 reports into Pro*C are writing the data to file during the "FETCH" sequence. The problem comes in that during this time, the programmer does not know how many lines of data will be generated from the SQL statement. This information is needed
for page number purposes. The programmer inserts the heading information
for each page that is created, but the heading contains the line Page # of #.

Granted, a counter could be created for the "Page #", but the total number
of pages is not known while the SQL is "fetching" each piece of data. What
would be the best way of putting in the total number of pages in the " of #"
part with as few database hits and increased file I/O operations? Also, if
you know of some libraries that do this sort of thing, please, let me know!

Thanks!

Melissa Received on Fri May 21 1999 - 10:31:16 CDT