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