Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!zaphod.mps.ohio-state.edu!van-bc!tacitus!clh
From: clh@tacitus.tfic.bc.ca (Chris Hermansen)
Newsgroups: comp.databases
Subject: Re: Informix isql
Keywords: order by, select, entry form
Message-ID: <152@tacitus.tfic.bc.ca>
Date: 12 Feb 90 22:17:37 GMT
References: <6548@uhccux.uhcc.hawaii.edu> <1990Feb11.084522.12120@halexii.uucp>
Reply-To: clh@tacitus.UUCP (Chris Hermansen)
Organization: Timberline Forest Inventory Consultants, Vancouver BC
Lines: 21

In article <1990Feb11.084522.12120@halexii.uucp> greg@halexii.UUCP (Gregory F. Hogg) writes:
>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
>
>	As fas as I know there is no way todo what you want in
>INFORMIX-SQL. The best I have been able to do is to unload the table

Well, you can build a CLUSTER INDEX on the field in question, and then drop
it.

Can you say kludge?  Sure you can, it's easy...

Chris Hermansen                         Timberline Forest Inventory Consultants
Voice: 1 604 733 0731                   302 - 958 West 8th Avenue
FAX:   1 604 733 0634                   Vancouver B.C. CANADA
uunet!ubc-cs!van-bc!tacitus!clh         V5Z 1E5
clh@tfic.bc.ca -or- Chris_Hermansen@mtsg.ubc.ca

May you work in an interesting place.