<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
No, you do not have to, just make sure you are checking the proper
field and understand that a normal record may appear multiple times,
once for each instance of 'true' being met according to your search
criteria.<br>
<br>
So, if I were to mimic what you said, as I understand it: One
record can be split into multiple payments and you have allocated
scheduled payments within the record<br>
<br>
I figure I would have my map to look like this<br>
<br>
a1) date 1<br>
a1) date 2<br>
a1) date 3<br>
a1) date 4<br>
....<br>
a2) amount 1<br>
a2) amount 2<br>
a2) amount 3<br>
a2) amount 4<br>
....<br>
a3) cc # 1<br>
a3) cc # 2<br>
a3) cc # 3<br>
a3) cc # 4<br>
...<br>
a4) appv code 1<br>
a4) appv code 2<br>
a4) appv code 3<br>
a4) appv code 4<br>
...<br>
a5) error 1<br>
a5) error 2<br>
a5) error 3<br>
a5) error 4<br>
...<br>
<br>
So, given this setup, you can have these anywhere within your map
they just need to be properly paired so that filePro can do its
thing as you would expect it.<br>
<br>
Now, all you have to do is set your selection criteria based on a1)
and process the payment|export based on "associated fields" a2, a3,
a4, a5 and if you need to use a field(s) outside the "associated
block", then do so as you normally would in filePro - 1, 2, 3, 4, 5
... <br>
<br>
As far as the export is concerned, I always like to use dynamic file
names and place the export command in a "subroutine - gosub mkexp"
so that I can have multiple routines create any number of export
files and not run into the problem that ONLY one export command per
processing table (not sure if this is still true today).<br>
<br>
<br>
:then: fn="/tmp/put-it-here.txt"; gosub MKEXP<br>
:then: ref(1)=a1); ref(2)=a2); ref(3)=a3); ref(4)=a4); ref(5)=1;
ref(6)=22; ref(7)=233;<br>
:then: write ref; end<br>
MKEXP:if:<br>
:then: export ascii ref = (fn) r=\n f=, -A<br>
:then: return<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 12/22/2015 05:40 PM,
<a class="moz-txt-link-abbreviated" href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>
</div>
<blockquote
cite="mid:CADpQzqNEhLTHx3b7jQRWyizaCX-=K6O39eojj--JtBY4qVCc2g@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Ok so to confirm - in order for this to work correctly, I
would need the amounts in a separate associate field?</div>
<div>Currently I have </div>
<div>a1) Date</div>
<div>a2)TransID (internal number)</div>
<div><br>
</div>
<div>but I don't have the amount in a?) - so that's why if I
have one transaction dated today for 50.00 and another dated
tomorrow for 57.00 - it has not way to associate the amount to
the proper date?</div>
<div>Or am I confused?</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Tue, Dec 22, 2015 at 5:37 PM, Jose
Lerebours via Filepro-list <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:filepro-list@lists.celestial.com"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a></a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">People,
remember that associated records are exactly that, records
within the record and you should not need to use @af to
point to the instance of the "record" or "array"<br>
<br>
So, if you have a1, a2, a3, a4 ... b1, b2, b3, b4 ...<br>
<br>
selecting records based on a1 eq @td, you just need to
reference the records based on their "associated field
names", meaning, use a1, a2, a3, ... Use what we know as
"real" fields if you need to use a field outside the
associated block<br>
<br>
a1) Date<br>
a2) Pay Amount<br>
a3) Credit Card Number<br>
a4) Approval Code<br>
<br>
:if: a1 eq @td<br>
:then: goto DOIT<br>
:: end<br>
DOIT:if:<br>
:then: process payment if cc merchant<br>
:if: ccpayment went ok<br>
:then: a4=ccpayment approval code; write<br>
::end<br>
<br>
<br>
or something to that effect.<br>
<br>
You only need to use @af you are not taking advantage of the
"associated fields" ... Then again, there is a chance I am
grossly mistaken and have used it wrong all these years.
;-)<br>
<br>
Hope all goes well!
<div class="HOEnZb">
<div class="h5"><br>
<br>
<br>
<br>
<br>
<br>
On 12/22/2015 05:25 PM, Mike Schwartz via Filepro-list
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
I have created a file that can have up to 12 credit
card transactions<br>
</blockquote>
dated<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
today or in the future...<br>
<br>
So each morning I want to send the current dated
ones to be processed but<br>
think I'm having a brain cramp on this...<br>
<br>
I have 12 fields that are date fields (each shows as
a1) Date of 1st Pmt<br>
a1) Date of 2nd Pmt, etc...then each has it's
corresponding amount....<br>
<br>
How would I select records dated just today and grab
the corresponding<br>
amount for that date?<br>
<br>
I have the index built and can search by that day,
but do I need to 'step'<br>
though each of the 12 dates and if it matches today
grab the amount in the<br>
amount field for that day?<br>
<br>
I tried this and am exporting these records but it
only exports the last<br>
</blockquote>
record<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
it finds with today's date??<br>
<br>
Scott<br>
PDM<br>
</blockquote>
Whenever you want multiple export lines to be
written to the export<br>
file from within one filePro record you have to use a
"write" command to<br>
"force" the write of the exported line out to the
file.<br>
<br>
You don't have to "step" (loop) through the 12
fields if you use @AF<br>
(associated field instance). @AF knows which date
instance (1-12) caused<br>
the index building to select the record.<br>
<br>
Mike Schwartz<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a moz-do-not-send="true"
href="mailto:Filepro-list@lists.celestial.com"
target="_blank">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a moz-do-not-send="true"
href="http://mailman.celestial.com/mailman/listinfo/filepro-list"
target="_blank" rel="noreferrer">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a moz-do-not-send="true"
href="mailto:Filepro-list@lists.celestial.com"
target="_blank">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a moz-do-not-send="true"
href="http://mailman.celestial.com/mailman/listinfo/filepro-list"
target="_blank" rel="noreferrer">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>