Re: Restricting queries to a certain number of rows?

Posted in 1996

David Williams — Wed, 19 Jun 1996 22:49:37 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <4q7hss$53i@cssun.mathcs.emory.edu>, "\\"Tom Hogarty\\"" <hogarty@pyramid.com> writes > > > >> On Jun 18, 4:17pm, Spetc@aol.com wrote: >> ... >> Does anybody know if it is possible to restrict the number of rows returned >> by the Online engine (Version ?.?). > >Yes, in Release 8.0 (XPS) the sql syntax is extended so that SELECT FIRST 10... >is made possible. Otherwise I only know of using a cursor and restricting your >fetches to the required number of rows. > >Hope This Helps > > > I've been trying to get more info on XPS but no-one seems to know what the new features are...how did you get this info and what else is new in XPS???? I didn't think XPS had been released yet...we have 7.12 and will get 7.2 but don't even have a release date for 8.0 -- David Williams