Path: utzoo!attcan!uunet!samsung!usc!jarthur!aqdata!sullivan
From: sullivan@aqdata.uucp (Michael T. Sullivan)
Newsgroups: comp.databases
Subject: Re: Informix isql
Message-ID: <1990Feb12.162507.612@aqdata.uucp>
Date: 12 Feb 90 16:25:07 GMT
References: <6548@uhccux.uhcc.hawaii.edu>
Organization: aQdata, Inc.  Western Region -- San Dimas, CA
Lines: 14

From article <6548@uhccux.uhcc.hawaii.edu>, by richardj@uhccux.uhcc.hawaii.edu (Richard Jablonka):
> 
> 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
> in an entry form you can only state the table name and you can't use the where
> or order by clause.

My guess is that you index the order you want and make that a clustering
index.  Since perform appears to show rows in their raw table order, this
will probably do what you want.
-- 
Michael Sullivan          uunet!jarthur!aqdata!sullivan
aQdata, Inc.              sullivan@aqdata.uucp
San Dimas, CA             +1 714 599 9992