multiple field index

[scooter6 at gmail.com]

Ok so to confirm - in order for this to work correctly, I would need the
amounts in a separate associate field?
Currently I have
a1) Date
a2)TransID (internal number)

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?
Or am I confused?


On Tue, Dec 22, 2015 at 5:37 PM, Jose Lerebours via Filepro-list <
filepro-list at lists.celestial.com> wrote:

> 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"
>
> So, if you have a1, a2, a3, a4 ... b1, b2, b3, b4 ...
>
> 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
>
> a1) Date
> a2) Pay Amount
> a3) Credit Card Number
> a4) Approval Code
>
> :if: a1 eq @td
> :then: goto DOIT
> :: end
> DOIT:if:
> :then: process payment if cc merchant
> :if: ccpayment went ok
> :then: a4=ccpayment approval code; write
> ::end
>
>
> or something to that effect.
>
> 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.  ;-)
>
> Hope all goes well!
>
>
>
>
>
>
> On 12/22/2015 05:25 PM, Mike Schwartz via Filepro-list wrote:
>
>> I have created a file that can have up to 12 credit card transactions
>>>
>> dated
>>
>>> today or in the future...
>>>
>>> So each morning I want to send the current dated ones to be processed but
>>> think I'm having a brain cramp on this...
>>>
>>> I have 12 fields that are date fields (each shows as a1) Date of 1st Pmt
>>> a1) Date of 2nd Pmt, etc...then each has it's corresponding amount....
>>>
>>> How would I select records dated just today and grab the corresponding
>>> amount for that date?
>>>
>>> I have the index built and can search by that day, but do I need to
>>> 'step'
>>> though each of the 12 dates and if it matches today grab the amount in
>>> the
>>> amount field for that day?
>>>
>>> I tried this and am exporting these records but it only exports the last
>>>
>> record
>>
>>> it finds with today's date??
>>>
>>> Scott
>>> PDM
>>>
>>       Whenever you want multiple export lines to be written to the export
>> file from within one filePro record you have to use a "write" command to
>> "force" the write of the exported line out to the file.
>>
>>       You don't have to "step" (loop) through the 12 fields if you use
>> @AF
>> (associated field instance).   @AF knows which date instance (1-12)
>> caused
>> the index building to select the record.
>>
>> Mike Schwartz
>>
>>
>>
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20151222/c119130e/attachment.html>