Re: table output order

Posted in 2000

Radu Dumitriu — Thu, 07 Dec 2000 22:56:59 -0800 — source: Informix-list mailing list archive (1991-1998)

This is a multi-part message in MIME format. --------------E6D9D00A662DCB65093CA86E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Don't be too rough on him@edu, he's learning (otherwise he wouldn't be asking that question ...). Peace, love, and flowerpower ;-) Radu 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? --------------E6D9D00A662DCB65093CA86E 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 --------------E6D9D00A662DCB65093CA86E--