multiple field index

[Mike Schwartz]

> 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