Path: utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!tut.cis.ohio-state.edu!pt.cs.cmu.edu!dsl.pitt.edu!pitt!darth!investor!rbp
From: rbp@investor.pgh.pa.us (Bob Peirce #305)
Newsgroups: comp.databases
Subject: Re: Informix isql
Keywords: order by, select, entry form
Message-ID: <1990Feb15.124528.17154@investor.pgh.pa.us>
Date: 15 Feb 90 12:45:28 GMT
References: <6548@uhccux.uhcc.hawaii.edu>
Reply-To: rbp@investor.pgh.pa.us (Bob Peirce #305)
Organization: Cookson, Peirce & Co., Pittsburgh, PA
Lines: 16

In article <6548@uhccux.uhcc.hawaii.edu> richardj@uhccux.UUCP (Richard Jablonka) writes:
>
>I want to SORT an informix table.  I only need to do it once.  The problem is 
>making the names come up in the right order in an entry form.   Unfortunately

The idea of unloading, sorting and reloading, mentioned in another follow-up
might work if you never plan to add any more records to the table.  I have
never tried it.  On the other hand, being equally frustrated with this
shortcoming of sperform, I have observed that certain queries do seem to
order the output.  I say seem, because I did not confirm this before
posting.  At any rate, numeric ranges (nnn:nnn) seem to get ordered as do
some string searches using wild-cards.  Perhaps "Dr. Scump" could comment.

-- 
Bob Peirce, Pittsburgh, PA				  412-471-5320
...!uunet!pitt!investor!rbp			rbp@investor.pgh.pa.us