Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!cs.utexas.edu!asuvax!ncar!ames!uhccux!richardj
From: richardj@uhccux.uhcc.hawaii.edu (Richard Jablonka)
Newsgroups: comp.databases
Subject: Informix isql
Keywords: order by, select, entry form
Message-ID: <6548@uhccux.uhcc.hawaii.edu>
Date: 10 Feb 90 23:17:52 GMT
Reply-To: richardj@uhccux.UUCP (Richard Jablonka)
Organization: University of Hawaii
Lines: 15


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.

Additionally,  I tried to set up a view using the order by clause but it just
says error when I tried.  

I even tried  "Select   order by   TO [newtable name]"  but the program says
you cant use the order by clause when you "pipe" to a new table.  Does anybody
have any suggestions?

                                        Thanks,
                                        Richard Jablonka, richardj@uhccux