<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
SELECT PAYTODAT WHEN PTD.BD.CODES = 'RRSB''RESB' BY.EXP PTD.BD.CODES<br>
LIST PAYTODAT TOTAL COUNTER should give you the 99 count that you are
looking for<br>
<br>
Minatra, Pat wrote:<br>
<blockquote
cite="mid645EBE386054B0459AA6602C88AE1D09062A06C5@exchange1.hsutx.edu"
type="cite">
<pre wrap="">I can do the following:
-----start snip
:GET.LIST SBAB.TOTAL
56 records retrieved to list 0.
</pre>
<blockquote type="cite">
<pre wrap="">SELECT PAYTODAT WITH PTD.BD.CODES = "RRSB"
</pre>
</blockquote>
<pre wrap=""><!---->
56 records selected to list 0.
</pre>
<blockquote type="cite">
<pre wrap="">CLS
</pre>
</blockquote>
<pre wrap=""><!---->:GET.LIST SBAB.TOTAL
56 records retrieved to list 0.
</pre>
<blockquote type="cite">
<pre wrap="">SELECT PAYTODAT WITH PTD.BD.CODES = "RESB"
</pre>
</blockquote>
<pre wrap=""><!---->
43 records selected to list 0.
</pre>
<pre wrap=""><!---->-----end snip
The two responses that I get where XX records selected to list 0 are the
numbers that I need to add together and put into a variable that
DOWNLOAD will recognize.
I.E.
56 records selected to list 0.
43 records selected to list 0.
--
99 total contributions (even though there are 56 records)
I know that I can do this in basic but this is the ONLY part of this
that does not work like it use to back in R16 days.
This is a vendor requirement and so far the ONLY solution is to manually
input this number prior to submittal and that is just not a very good
solution.
Thanks for any help and have a GREAT day!
-------------------------
"Life is but a twinkle in the eye of eternity"
"The shortest distance between a problem and a solution is the distance
between your knees and the floor"
"sorrow looks back - worry looks around - faith looks up"
Regards,
Pat H. Minatra - N5GJR
(325) 670-5804 voice
(325) 670-1570 fax
Hardin*Simmons University
<a class="moz-txt-link-abbreviated" href="http://www.hsutx.edu">www.hsutx.edu</a>
PO BOX 16040
Abilene, TX 79698
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:download-list-bounces@cedarville.edu">download-list-bounces@cedarville.edu</a>
[<a class="moz-txt-link-freetext" href="mailto:download-list-bounces@cedarville.edu">mailto:download-list-bounces@cedarville.edu</a>] On Behalf Of Minatra, Pat
H.
Sent: Tuesday, May 02, 2006 8:01 AM
To: <a class="moz-txt-link-abbreviated" href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a>
Subject: [Download-List] Using TOTAL COUNTER
I wrote a paragragh in UniData in 2001 whereby I am taking data and
placing it into three different files and then concatenating it into one
file as a final submittal file to be used as electronic submittal.
The TOTAL COUNTER process use to count the contributions and now ONLY
counts records.
Example:
A record can have an employer contribution (always) and MAYBE an
employee contribution.
I was using the TOTAL COUNTER to total how total contributions (not
records) were actually made; 25 records, employer contributes 25 times,
employees contribute only 12, toal would be 37 but TOTAL COUNTER now
reports 25 and use to report 37. I have not changed the code but the
counting 'result' changed in 2003 (which is the SAME time we came up on
R17 but that should not have made a difference).
So, my question is...is there some keyword I can use to be able to get
this number and report the number out to the third file which uses this
'total' number of contributions and not line items.
Thank you so much for any and all help. Have a GREAT day!
-------------------------
"Life is but a twinkle in the eye of eternity"
"The shortest distance between a problem and a solution is the distance
between your knees and the floor"
"sorrow looks back - worry looks around - faith looks up"
Regards,
Pat H. Minatra - N5GJR
(325) 670-5804 voice
(325) 670-1570 fax
Hardin*Simmons University
<a class="moz-txt-link-abbreviated" href="http://www.hsutx.edu">www.hsutx.edu</a>
PO BOX 16040
Abilene, TX 79698
_______________________________________________
download-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a>
<a class="moz-txt-link-freetext" href="http://mail.cedarville.edu/mailman/listinfo/download-list">http://mail.cedarville.edu/mailman/listinfo/download-list</a>
_______________________________________________
download-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a>
<a class="moz-txt-link-freetext" href="http://mail.cedarville.edu/mailman/listinfo/download-list">http://mail.cedarville.edu/mailman/listinfo/download-list</a>
</pre>
</blockquote>
</body>
</html>