Re: SQLPLUS and computed totals

In article <32E50B13.571_at_telesph.com>, janet <janet_at_telesph.com> wrote:
>i hate seeing a "nothing you can do" so here's
>a clunky solution for you:
>skip the breaks and computes, at the end of the
>report compute the sum yourself.
>select count(carbno), count(dte_comp), count(*)
>from table;
>
>of course, if the data is changing during report run,
>this won't be accurate.

Could you not put a SET TRANSACTION... round both queries to make sure there both running off the same set of date. Or am I talking cack again.

Ian.

*----------------------------------------------*
*  "Think for yourself - Question Authority"   *
*  Dr. Timothy Leary (1920 - 1996)             *
*----------------------------------------------*