Associated fields and @AF

[Jay R. Ashworth]

On Thu, Jun 23, 2005 at 08:55:12AM -0500, Chad McWilliams wrote:
> > I think what you are missing (and perhaps this was not 
> > mentioned in the manual) is that you need to sort by the 
> > associated field for this to be effective.
> > 
> > Jeff Harrison
> > jeffaharrison at yahoo.com
> > 
> > Author of JHImport and JHExport. The fastest and
> > easiest way to create code for filePro Imports and
> > Exports. 
> 
> I'm not trying to disagree with you, but I don't understand what sorting
> would have to do with the situation.  All the work is being done within a
> single record, so, as I see it, sorting should have no effect within the
> individual record.

Because @AF *is not set by filepro* unless you sort on the associated
field?  :-)  What @AF says is "which of the associated fields in the
group is the one responsible for *this* appearance of this record in
the temporary output sort file?"  If you don't sort by the associated
field, it doesn't fill that it.  I'm surprised it's 1, I'd expect it to
be 0... (which would throw an error, and thus be better).

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

      If you can read this... thank a system administrator.  Or two.  --me