Re: table output order
This is a multi-part message in MIME format. --------------E4E725E7D1672487D7AB2AAA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You know, Ob, I know that you are a smart one, I sure of that ... But being so smart, try to answer only at the questions that suit your intelligence, and leave all those silly questions on behalf of the other guys, who do not know as much as you .... I sure that we'll find lots of... Don't misunderstand me ... I like your acid replies, even directed at me ... ...and I'm expecting one, course. Same, Radu P.S. ." ...and he is like the dragon which flies up in the sky where no arrow can touch it ..." (Confucius about Tao - approx.) Don't tell me that this didn't raise your ego ... ;-) Obnoxio The Clown wrote: > From: Radu Dumitriu <radu@goldenclick.com> > > > >Don't be too rough on him@edu, he's learning (otherwise he wouldn't be > >asking > >that question ...). > > A good place to start learning is RTFM. Then ask questions. > > >Murray Wood wrote: > > > > > ORDER BY 1, 2, 3 > > > The SQL Syntax manual! > > > > > > -----Original Message----- > > > From: owner-informix-list@iiug.iiug.org > > > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Richard E. > > > Hassler > > > Sent: Friday, December 08, 2000 10:49 AM > > > To: informix-list@iiug.org > > > Subject: table output order > > > > > > I have the latest version of SE (7.?) running on an HP-UX version 10.2. > > > > > > I set up a table of 3 fields one of which is a sequencial number from > > > 1-700. The sequential column is indexed. The data is loaded into the > > > table in ascending order, i.e. 1 2 3 . . . > > > > > > When I do a 'select * from tablename' in SQL or do an escape in the > > > sequential field in a PERFORM screen the rows are displayed in reverse > > > order by sequential number, i.e. 700 699 698 . . . I would like them to > > > list in ascending order, i.e. 1 2 3 . . . Is there any way to do this? > ><< radu.vcf >> > > _____________________________________________________________________________________ > Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com --------------E4E725E7D1672487D7AB2AAA Content-Type: text/x-vcard; charset=us-ascii; name="radu.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Radu Dumitriu Content-Disposition: attachment; filename="radu.vcf" begin:vcard n:Dumitriu;Radu x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:radu@goldenclick.com x-mozilla-cpt:;13888 fn:Radu Dumitriu end:vcard --------------E4E725E7D1672487D7AB2AAA--