The translate returns MV data with spaces. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED]
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rod Hills Sent: Wednesday, September 01, 2004 9:11 AM To: [EMAIL PROTECTED] Subject: [U2] Correlative referencing multi-value field in another file We are trying to do a very basic PICK technique of summing a multi-value field in a F-type correlative. However, it appears uniVerse is not putting the multi-values onto it's "stack" as inividual values, but rather as one entry with the value markers replaced with blanks. Below are two dictionary definitions, the only difference is WO.COMPL.QTY does a sum as its last step. As can be seen by the LIST output, only single-value entries return a non-zero value. Anyone else come across this? And should it be working this way? We are on UV10.0.16 and HPUX11i. Thanks in advance -- Rod Hills WO.COMPL.QTY 0001 A 0002 0 0003 Wo Compl}Total 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8);S 0009 R 0010 8 WO.QTY.COMPL 0001 A 0002 0 0003 Wo Qty Compl 0004 0005 0006 0007 0008 F;0;(G0*1);(TWIP;X;;8) 0009 R 0010 12 LIST WIPOPERACT WO.COMPL.QTY WO.QTY.COMPL 10:05:27am 31 Aug 2004 PAGE 1 WIPOPERACT Wo Compl Wo Qty Compl Total... 89783*560 4 4 89433*111 0 14 1 78574*370 0 3 5 6 1 5 84804*780 0 2 2 3 3 5 3 88810*070 0 R7735*380 0 15 2 1 89922*630 0 60330*001 0 79101*000 0 18 60 5 2 10 3 2 90032*050 0 82930*110 0 88671*001 2937 2937 90449*260 0 3 20 4 3 60268*790 0 60129*720 0 79312*380 2 2 ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
