This data set is only used to "browse" i.e. to look and find part numbers that you don't know. The program allows searching by category and it difficult to find a part number when they are in order of when the part was entered. I would have thought that this sort should/could be done by the program but it isn't and the vendor will not fix(enhance) it. It is much easier to find the part numbers when all the similar part numbers are grouped together(sorted by part number). The batch repack/fix path with adager took all of 43 seconds last night and all is well. Thanks all for dusting out the cobwebs on image sort fields. Bill Grefe [log in to unmask] -----Original Message----- From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of Mark Landin Sent: Thursday, March 09, 2000 8:56 AM To: [log in to unmask] Subject: Re: sorting image data On Wed, 8 Mar 2000 09:25:34 -0500 , bill grefe <[log in to unmask]> wrote: >I have an image data set(see below). I would like to have this data returned >from image sorted by >Catalogue-number regardless of the search path used to find the data. The >programs that use this >Data set are supplied by a third party and I have no access to them. >Can I a) add a sort path with adager to catalogue-number (without breaking >anything) or > b) sort the data with adager periodically (I used to do this with >DBMGR reload along time ago >but I think they "enhanced" reload so the order of the non sorted search >paths weren't changed). Well I've seen some possible solutions to your problem ... but I'd like to ask something nobody else has ... "why"? There may be more than one way to skin this particular cat (apologies to any SPCA members offended by this cliche) ... perhaps there are alternatives to sorting the actual dataset that are less painful or more efficient. So ... WHY do you want to have the entries come out of the DB in this particular order?