Two for the road, Report from Clerk & Nonstandard Subtotals
John Esak
john at valar.com
Mon Mar 14 19:14:33 PST 2005
> >
> > P.S. - I'm not clear how you get the free record to
> > "end" , and thereby
> > generate the @wgt processing.
> >
> >
>
> Sorry John. I realized a fraction of a second after I
> replied that I did not include the list as I had
> intended. So I did re-forward it to all.
>
> As to how I get the free record to end, it goes
> something like this. (this is just off the top of my
> head, but I think you'll get the idea)
>
> loop:::
> ::lookup src = transaction@ k=fr i=a -ng:
> :not src:goto fini:
> :src(2) gt to:goto fini:
> ::lookup des = ("transaction@"{qual) r=free -e:
> ::copy src to des:
> ::lookup tmp = ("subtotalfile@"{qual) k=(src(1)) i=a
> -nxp:
> :not tmp:lookup tmp = ("subtotalfile@"{qual) r=free
> -e:
> ::tmp(2)=tmp(2)+src(3):
> ::goto loop:
> fini:::
> ::close des; close tmp:
> ::system "/appl/fp/dreport transaction -m "<qual '
> etc:
>
> The close commands make sure the record locks on both
> lookups get released. Therefore the report should not
> have a problem running through the qualified
> transaction file, and all of the subtotal records
> should be available to lookup @wgt.
>
> Jeff Harrison
> jeffaharrison at yahoo.com
No, no, no. Jeff, you completely misunderstood the point of my twist. What
you explain here (and very well, I might add) is just the "usual" way of how
to run a report from clerk. It is dead-simple as I showed in great detail.
There is no need to do anything special when you are running through a
*different* file from the one you are standing in. If that were all there
was to it, there would have been NO point to my whole discussion. That is
why I showed it first, and then said... NOW here is the twist... :-) What
is hard, nigh on to impossible is to get a record to stand on and run as a
record in its own right... in fact, I think the way I showed is the _only_
way to do it. I was hoping you had another... but you are just doing the
same old, same old we have all been doing for years with spin-offs. Not at
all what I was showing with my special twist. So, still I guess, there is
only this one way. Don't feel bad, it took me hours to finally come up with
that solution. But, if you do come up with a better or even just different
way to do it, let me know! :-)
Thanks,
John
More information about the Filepro-list
mailing list