multiple field index

[scooter6 at gmail.com]

I was using a different index in my output other than a1) - I think that
did the trick....
I knew I was brain farting on something lol
thanks all

On Tue, Dec 22, 2015 at 5:25 PM, Mike Schwartz via Filepro-list <
filepro-list at lists.celestial.com> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20151222/c52eb6ec/attachment.html>