Associated fields question

Jaime Perry jaime at hoovercs.com
Thu Mar 30 09:18:36 PST 2006


The associated field in question that I am using has 10 fields.  Do you 
mean all 10 need to have data for @af to report something other than 
"1"?  That it will not work if 2 of 10 or 5 of 10 or whatever of 10 
fields have data?

Jeff Harrison wrote:
> --- Jaime Perry <jaime at hoovercs.com> wrote:
>
>   
>> Jeff Harrison wrote:
>>     
>>> @af would not be "1" necessarily, the first time
>>>       
>> you
>>     
>>> encounter the record.  The @af value will
>>>       
>> correspond
>>     
>>> to the "row number" within the associated field
>>> grouping.  For example if you had A0) as your
>>> associated field group in your map as follows with
>>>       
>> the
>>     
>>> following values for record #1:
>>>
>>> Field #   Group     Value
>>> 1         A0)       BBB
>>> 2         A0)       BBB
>>> 3         A0)       AAA
>>>
>>> If you sort the output by A0) then @af will be "3"
>>>       
>> on
>>     
>>> the first record when you are processing the "AAA"
>>> value.  This is because it is the third instance
>>>       
>> of
>>     
>>> A0) in the map.
>>>   
>>>       
>> Correct, I stated that wrong.
>>     
>>> You should certainly not be getting "1" for all of
>>>       
>> the
>>     
>>> values of @af, unless you are only using the first
>>> instance of the "row" in you map. 
>>>
>>>
>>>   
>>>       
>> What do you mean by "using the first instance of the
>> "row" in your map"?
>>
>>
>>     
>  
> In my example above that would be if you only had data
> in field #1 - not in fields 2 or 3 in the record.
>
> Jeff Harrison
> jeffaharrison at yahoo.com
>
> Author of JHExport and JHImport.  The easiest and
> fastest ways to generate code for filePro exports and imports.
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20060330/a9b60953/attachment.html


More information about the Filepro-list mailing list