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?