Re: Restricting queries to a certain number of rows?

Posted in 1996

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

In article <4q7et2$15q@cssun.mathcs.emory.edu>, Spetc@aol.com writes >Does anybody know if it is possible to restrict the number of rows returned >by the Online engine (Version ?.?). > >Clearly rows past say, 100, can be discarded in the application, but I would >prefer to tell the engine not to return more than 100. No it is not possible - OnLine always returns all the rows from a query, -- David Williams