Re: table output order

This is a multi-part message in MIME format. --------------9AD4C418926DC2DC4CA10027 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Obnoxio The Clown wrote: > From: Radu Dumitriu <radu@goldenclick.com> > > > >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. > > I hate disappointing people. > > All I can say is: bollocks. There are outstanding manuals available to > everyone with a web browser or a CD drive. They get shipped with the > product. I'll answer any question that shows that some effort has gone into > the matter beforehand. I will even look into questions where it isn't > obvious in the manual. But how to stick data into a database is something > it's reasonable to expect is in a book somewhere. > > >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 ... ;-) > > Bollocks to that too. I prefer the one about "...soaring with eagles, but at > least weasels don't get sucked into jet engines..." :-) That was fine. You did not disappoint me ... not at all... :-) > > > And there's plenty of proof around that I'm fallible and occasionally need > to RTFM (or something) too. irony....i didn't mean it, you know ... > > > But that one was just stupid. But you are still *trying* not to get the point... :-) Radu > > > >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 > ><< radu.vcf >> > > _____________________________________________________________________________________ > Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com --------------9AD4C418926DC2DC4CA10027 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 --------------9AD4C418926DC2DC4CA10027--