Re: Restricting queries to a certain number of rows?
Posted in 1996
Tim Schaefer — — source: Informix-list mailing list archive (1991-1998)
Spetc@aol.com wrote: > > 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. FOREACH cursor INTO something.* LET counter = counter + 1 IF counter >= 100 THEN EXIT FOREACH END IF END FOREACH -- \\\\|// (6 6) ==============================---o00--(_)--00o---============================ Tim Schaefer tschaefe@encore.com tschaefe@shadow.net www.shadow.net/~tschaefe =============================================================================