Re: including sqcs - not finding them?

[Pankaj Bedekar <BedekarP@ALCONEMARKETING.COM>]

Its ur -I option .....
You have both paths where ur new SQC is and where your old SQC is in there
....... but sqr IS findinf you old sqc before your new so its using old ...
When u changed name old sqc is not in picture anymore ..... so it goes to
directory of ur new 'getcodta1.sqc'     (as per path in -i) and uses that
...

Change the definition on -I ... give both paths in that but use ur custom
sqc directory BEFORE  deliverd one ... ( if still does not work use it
AFTER)

Pankaj






-----Original Message-----
From: Andrew Lin [mailto:alin@TECHNEGLAS.COM]
Sent: Thursday, April 25, 2002 3:01 PM
To: SQR-USERS@list.iex.net
Subject: including sqcs - not finding them?

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