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