<br><br><div class="gmail_quote">On Mon, Mar 25, 2013 at 11:21 AM, Kenneth Brody <span dir="ltr"><<a href="mailto:kenbrody@spamcop.net" target="_blank">kenbrody@spamcop.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
In answer to the recent "rreport vs. dreport" thread, along with the "I've<br>
been using filePro for ${BIGNUM} years, and I've never run into this before"<br>
comments...<br>
<br>
I hope this clears things up.<br>
<br>
======<br>
<br>
Short answer:<br>
<br>
If you want a "blanket rule", it would be "you *should* compile the output<br>
processing with the same '-y' table as you will run it with -- however, in<br>
nearly all cases, the difference in compilation will have no effect on<br>
filePro during runtime".<br>
<br>
But, in those few cases where it *does* have an effect, that effect will<br>
cause the report to fail to run properly if not compiled properly<br>
<br>
======<br>
<br>
Long answer:<br>
<br>
The difference has to do with the "multi-level copies" of dummy fields,<br>
which allows you to use a single dummy field to hold multiple subtotal<br>
values. (See my article in Smalltalk #9.3 pp7-11, "Output Processing:<br>
Subtotals, Dummy Fields, Aliases and Arrays" for more details if you are<br>
unfamiliar with this feature.)<br>
<br>
Specifically, it has to do with whether the dummy field you are using to do<br>
such subtotalling is defined in automatic processing, but not in the "-y"<br>
override. And, whether you use that field to accumulate a value without<br>
having executed an explicit assignment to that field.<br>
<br>
For example:<br>
<br>
aa = aa + ytd_sales<br>
<br>
without executing something like:<br>
<br>
aa = ""<br>
or<br>
aa = some_value<br>
<br>
IF you are using a dummy field for multi-level subtotalling,<br>
<br>
AND IF you accumulate a value into that dummy field without an explicit<br>
assignment,<br>
<br>
AND IF you are running rreport with a "-y" table that does not define that<br>
dummy field,<br>
<br>
AND IF your default "automatic" processing table does define that dummy field,<br>
<br>
AND IF you compile the output table without the corresponding "-y" (or you<br>
do use a "-y", but that table also does not define that dummy field),<br>
<br>
THEN, the output may not run correctly.<br>
<br>
======<br>
<br>
But, as I said above, the rule of thumb is that you "should" compile it with<br>
the corresponding "-y", even though probably >99% of the time it's not going<br>
to make a difference (as noted by the "I've never run into this in all my<br>
years of programming filePro" comments), because that one time it does<br>
matter, it matters big.<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
Kenneth Brody<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a></font></span></blockquote><div><br>In short, the above is NOT the case with the very example I sent to fptech, they still have the files, so that can be verified. <br>
<br>I'm done on this subject, I've resigned myself to the fact that I
now have go through all my menus and find out which of my 5,243
processing tables have to be recompiled with an alternate processing
table.<br>
<br>We're in the middle of writing a version control library for our
filePro processes, and will modify that to include which auto process is
to be compiled with every output process that is checked in/out and
will issue a system command to compile both on check-in.<br>
<br>One would have thought that if this was a requirement of rreport,
that when using rcabe, upon asking the question "Do you wish to create a
Runtime table?" that rcabe would prompt for the associated automatic
process with a default of auto, and compile that at the same time.<br>
<br>Like I said, I'm done with this subject, we will put the measures into place ourselves. <br></div></div><br>