Did you try LIST.INDEX GLPOST ? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett Sent: Wednesday, August 15, 2007 13:33 To: [email protected] Subject: RE: [U2] UD: Using indexes in UniQuery
Martin: This is not the case. The dictionary looks like: 2 Demo (0)-> .X AE DICT GLPOST INDEX_2 Top of "INDEX_2" in "DICT GLPOST", 9 lines, 364 characters. *--: P 001: I This is the INDEX dictionary that determines what the index is for this file. DO NOT add anything else to the 'correlative' field!!! 002: OCONV( CLIENTNO, 'MR%4' ) : YRMO_PSTD : OCONV( ACCTNO, 'MR%6' ) : OCONV( @ID, 'MR%8' ) 003: 004: 005: 24L 006: S 007: ...and the output looks like the initial email. 2 Demo (0)-> list GLPOST WITH INDEX_2 LIKE "0605..." INDEX_2 list GLPOST WITH INDEX_2 LIKE "0605..." INDEX_2 13:32:07 Aug 15 2007 1 GLPOST INDEX_2................. 583056 060520030800307000583056 726857 060520040100500000726857 583057 060520030800500000583057 726858 060520040100400000726858 583058 060520030800306000583058 . This suggests the index isn't used at all, as the output should be sorted properly. Hope this helps. Bill >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >Martin Phillips >Sent: Wednesday, August 15, 2007 1:11 PM >To: [email protected] >Subject: Re: [U2] UD: Using indexes in UniQuery > >Hi Bill, > >The index system should be able to handle a trailing wildcard. My immediate >thoughts are that the relevant dictionary item might be defined as right >justified which would result in a right justified sort in the index tree >which may in turn prevent use of the index for this item. > >Please check if this is the case and let me know. If it is the cause of your >woes, you will need to delete the index, modify the dictionary item and then >recreate/build the index. > > >Martin Phillips >Ladybridge Systems Ltd >17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB >+44-(0)1604-709200 ------- 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/
