Re: Reversal of Records

>> From uunet!rmy.emory.edu!informix-list-owner Fri Nov 22 12:04:07 1991 >> Subject: Re: Reversal of Records >> >> OK people, my turn. Nobody has yet mentioned VIEWS. Why can't you set >> up a view of the form >> >> CREATE VIEW viewtab AS >> SELECT * FROM tab >> ORDER BY serial>> >> You can then use this view in Perform for both inserting and retrieving, >> and of course it will also work for reports. >> >> Tell me why not? Because you can't have ORDER BY in a view definition, that's why. >> Tony Lacy-Thompson >> DB Product Manager, Informix UK >> Author of "INFORMIX-SQL, a Tutorial and Reference" Something this basic is missing from the book? >> MAIL: tonylt@informix.co.uk >> UUCP: ...!uunet!infmx!asterix!tonylt -- Alan Denney # aland@informix.com # {pyramid|uunet}!infmx!aland "Now they'll have this "Chunnel" thing, parallel tunnels running between England and France. Let's see. The English drive on the left side, and the French drive on the right side. Hmmmmm. That's going to be one *busy* lane!" - John Mendoza