RE: [sqr-users] DDP003.SQR with 3rd Array

[Bob Stone <bstone@fastenal.com>]

Is there a chance that the variables you're using to insert into the array
are never reinitialized to 0?  What I mean is that they could be growing and
growing each time you put and get.  SQR's infamous for it's varaibles not
being 0 when you come back into a procedure...try reiniting them to 0,
selecting the data, then putting them to the array.  (or whatever steps you
do before putting them in the array)

bob

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
Ramzi_Salameh@daveandbusters.com
Sent: Tuesday, June 21, 2005 3:52 PM
To: This list is for discussion about the SQR database reporting
language from Hyperion Solutions.
Subject: Re: [sqr-users] DDP003.SQR with 3rd Array


Other than the fact that PeopleSoft purchased and made their own version 
of SQR in tools 8, we've not encountered any issues with arrays.  We're on 
Tools 8.16 and 8.45.

-----------------------------------------------------
Ramzi Salameh
Senior Technical Analyst
(214) 904-2550

Dave and Buster's, Inc.
-----------------------------------------------------




"Wright, David L. II" <DAVID.L.WRIGHT.II@saic.com>
Sent by: sqr-users-bounces+ramzi_salameh=daveandbusters.com@sqrug.org
06/21/2005 10:43 AM
Please respond to "This list is for discussion about the SQR database 
reporting       language from Hyperion Solutions."
 
        To:     'SQR Users Group' <sqr-users@sqrug.org>
        cc: 
        Subject:        [sqr-users] DDP003.SQR with 3rd Array


Greetings,

I've got an issue that has PeopleSoft stumped.  So, I thought I'd ask the
SQR experts - you.

We added a 3rd array to DDP003.SQR to collect "begin/end" information on
multiple .prn output files.  The .prn files are the advices themselves 
that
we FTP to a Vendor who prints the advices.  The array is then referenced 
at
eoj time to create a summary report of the .prn files created - File Name,
starting/ending advice #, etc.  This "log" is also sent to the Vendor.  If
the Vendor has to reprint any advices, they reference the log for a
starting/ending file to reprint.

What's happening is after the first EE's advice is printed, every EE after
that has their current Fed Med/EE deduction amounts in the $millions.  And
it
continues to grow with each subsequent EE.  The SQR works fine without the
3rd array.

I believe that the 3rd array is somehow being stepped on by something else 
-
another array or something internal unbeknownst to me.

The puzzling thing is, this SQR works fine in 7.51.  HRMS 8.8 SP1, Tools
8.45 seems to have difficulty with the 3rd array.  Is there anything
different in release 8 having to do with arrays?

If anyone can shed some light on this I would be very appreciative.

Thanks in advance,

Dave

David L. Wright, II
SAIC - Sr. Technical Consultant, PeopleSoft
E-mail: david.l.wright.ii@saic.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users