@AF Clarification Needed...

[Kenneth Brody]

On 10/3/2011 11:25 AM, Stanley - stanlyn-com wrote:
> Hi,
>
> Does the @AF function and behavior work the same whether the table is
> structured as in table A and table B below?  I am having problems with @AF
> when using it with table A below, and NO problems with table B.  Define
> Proc=5.0.14D4, sco OpenSrv5
>
> Table A (with each associated field in a block where they are NOT next to
> each other)
>
> 90- I2) Item #1
> 91- Q2) Qty #1
> 92- M2) UOM #1
[...]
> 98- I2) Item #2
> 99- Q2) Qty #1
> 100- M2) UOM #2
[...]
>
> Table B (with each associated field next to each other)
>
> 38- D1) PayDate #1
> 39- D1) PayDate #2
> 40- D1) PayDate #3
[...]
> 49- G1) G/L Code #1
> 50- G1) G/L Code #2
> 51- G1) G/L Code #3
[...]
>
> And yes, I know how to normalize.  This is legacy code that needs some small
> changes to the @AF stuff.

No, it doesn't matter whether the fields are contiguous or not.

Can you define "having problems with @AF"?

-- 
Kenneth Brody