Doing a sort from ECL/TCL, ECL Type P
Have a field that is a straight D-type dictionary item, multi-valued
PLINE
001: D
002: 6
003:
004:
005: 6R
006:
007:
008: VARCHAR2
009:
010: A!6!!!!!!!L!6
011:
012: }}
Value Type (6) is blank on purpose for this email
If I do SORT FILE WITH 26 OR WITH NO MATCH BY TYPE BY 26 BY L BY-EXP PLINE
BY INV_n_ ID-SUPP BREAK-ON TYPE "'P'" BREAK-ON 26 BREAK-ON L INV-DATE CUST
CUST-NAME ORDER-NBR WHSE BREAK-ON PLINE TOTAL PROD-SUB TOTAL PROD-COST
GRAND-TOTAL "TOTALS FOR MY LITTLE SHOP CO., INC." HEADING "'C'MY LITTLE SHOP
CO., INC. 'LC'NOT-SO-LITTLE MONTH-END REPORT AS OF 'D' 'L'PAGE 'PL'"
A 11/17/2006 123456 SOME COMPANY NA 432529 VAL 04
134.90 101.17
04
24.44 18.32
04
37.64 28.22
04
12.22 9.16
******
---------- ----------
04
209.20 156.87
04
04
04
If I change the dictionary item field 6 to M, then the report changes to:
A 11/17/2006 123456 SOME COMPANY NA 432529 VAL 04
134.90 101.17
24.44 18.32
37.64 28.22
12.22 9.16
A 11/17/2006 123456 SOME COMPANY NA 432529 VAL 04
134.90 101.17
24.44 18.32
37.64 28.22
12.22 9.16
A 11/17/2006 123456 SOME COMPANY NA 432529 VAL 04
134.90 101.17
24.44 18.32
37.64 28.22
12.22 9.16
A 11/17/2006 123456 SOME COMPANY NA 432529 VAL 04
134.90 101.17
24.44 18.32
37.64 28.22
12.22 9.16
******
---------- ----------
04
836.80 627.48
The total from the first display is correct, although the display is
incorrect by repeating the 04 3 more times after the total
In the second, it reports the same company 4 times, and each time entails
all 4 multivalues
I should mention this was working, and I/we have no idea what changed to
break it
What simple thing have I missed????
Bob Wyatt
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
