Wrong ! You can set up a single item to be sorted on by EVERY path. The primary path is the path that is optimized the best. Right ! You cannot sort CATALOGUE-NUM on CATALOGUE-NUM. If you want to get all the CATALOGUE-NUM sorted, add a dummy-item to your set and set it to the same value every time, then put a sorted path to CATALOGUE-NUM. For instance: ALL-CATALOGUES X2 Set each entry to "**" for ALL-CATALOGUES. Set up your detail as follows: ALL-CATALOGUES ( ALL-CAT-AUTO-MAST (CATALOGUE-NUM)) In your program FIND ALL-CATALOGUES = "**", then do a chained read and they will all be in order ! > -----Original Message----- > From: Robert Grimes [SMTP:[log in to unmask]] > Sent: Wednesday, March 08, 2000 11:14 AM > To: [log in to unmask] > Subject: Re: sorting image data > > Ok, I know I'm in over my head on this group, and it has been a LONG > time sense I learned this stuff, and Image may have evolved more than I > was aware sense then, but it was my understanding that each sort item > could only be sorted on one path. By default, the primary path. And, I > don't see how it can be sorted on it's own path. I.E.: CATALOGUE-NUM > sorted on the CATALOGUE-NUM path. > > An example from my past. We had a set that had paths of id#, ss#, and > receipt#. The primary, and sorted path was on id# for the search sort > of receipt#. When read on the id# path the receipt# was sorted, because > the actual path was sorted on this field. When read on the ss# path, > the receipt# was not sorted. The only work around for this was that > first they were usually added in order, and seldom out of order anyway, > and second, we could do a physical sort on the receipt# with DBGeneral > if needed. > > Is my memory that bad, or my information that old? > > bill grefe 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). > > > > SET NAME: > > BROWSE-DETAIL,DETAIL > > > > ITEMS: > > CATALOGUE-NUMBER, U20 <<SEARCH ITEM>> > > CLASS, U6 <<SEARCH ITEM>> > > SUBCLASS, U6 <<SEARCH ITEM>> > > CATEGORY, U10 <<SEARCH ITEM>> > > TYPE, U4 > > > > CAPACITY: 8320 ENTRIES: 8198 > > > > Thanks, > > > > William Grefe > > [log in to unmask] > > PCI-WEDECO Environmental Technologies, Inc. > > phone: 973-575-7052 > > fax: 973-575-8941 > > -- > Robert P. Grimes Phone: (254) 526-1148 > Programmer/Analyst Fax: (254) 526-0817 > Central Texas College P. O. Box 1800 > [log in to unmask] Killeen, Texas 76540-0999