Re: including sqcs - not finding them?

[Bob Helm <Bob.Helm@MEDIWARE.COM>]

This may seem stupid, but could it be the editor that you use?
I usually use Brio.Report Builder and if I've had a file open and then open
a second file of the same name, it appends a '1' to the end of the file name
(or a '2', '3', etc.). For example, I had a file named 'Okidata.sqr' open. I
closed it out. Opened another updated 'Okidata.sqr' that was sent to me via
email. When I opened the second updated file, the editor renamed it
'Okidata1.sqr', so not to confuse it with the original. Well, it's easy to
not catch the '1' and just save it as such.


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


Hi Pankaj and Holger,

Thanks for replying.

Originally (when it was not working), there was only one sqc.  That was
the edited version of the original sqc (not a renamed copy).  The -i
only pointed to one directory(the one where the edited sqc resided).
Are you saying that sqr searches some other default directory before
looking at the path defined in -i?

My command line looked something like:

P:\brio\sqr614\ORA\BINW\sqrw.exe -iP:\hrtest\sqr\
-ZIFP:\hrtest\sqr\pssqr.ini
(only one path defined in -i)

The actual sqr as well as the edited sqc both resided in
P:\hrtest\sqr.

I suppose sqr could have got confused and grabbed the include file from
one of the other folders... (\hrdemo\sqr or \hrdev\sqr).

-Andrew



(Btw, there was a typo in my original posting... should have said 'then
made a copy of the sqc and called it 'getcodta1.sqc'....if anyone is
keeping score)

>>> BedekarP@ALCONEMARKETING.COM 04/25/02 06:18PM >>>
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

>>
Andrew,

I don't know if you had more than one path in your -I path, which would
have
caused your sqr to pick up a different copy of the SQC.  Once you
renamed it
with a "1", that copy of the SQC did not exist in the other directory.
I
think this is the most plausible answer, since I don't think your SQR
would
compile if it did not find an SQC called getcoda.sqc.

Regards,

Holger Noreke




-----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