including sqcs - not finding them?

[Andrew Lin <alin@TECHNEGLAS.COM>]

Hi all,

The 'problem' I'm facing is technically already solved; I'm just not
sure why it worked and why it was having problems in the first place.

We edited a delivered PeopleSoft SQC (getcodta) to pull customized
fields off of the company table.  For some reason, the main SQR kept on
reporting that the customized fields (being pulled in the sqc) were not
defined.  We suspected the sqr was not finding the customized sqc, and
sure enough, when we placed 'show' statements into the sqc, they didn't
show up.

We played with different flags (-i) assuming that sqr was checking the
wrong directory for sqcs.

Then I simply changed the include in the original sqr to:

#include 'getcodta1.sqc'     !just added a 1

and then made a copy of the sqc and called it 'getcodeta1.sqc'  and
left it in the same directory.

Voila!  It worked.

So... WHY did renaming the sqc work?  It's almost as if SQR uses some
sort of cache that is not always refreshed with fresh SQC data.

Ideas?  Suggestions? Comments?  Deep thoughts?

thx.

-Andrew