Re: Restricting queries to a certain number of rows?

john@a3bgate.nai.net wrote: > > Spetc@aol.com wrote: > : }FOREACH cursor INTO something.* > : } LET counter = counter + 1 > : } IF counter >= 100 THEN > : } EXIT FOREACH > : } END IF > : }END FOREACH > > : Wouldn't this still take "ages", because of the fact that FOREACH would still > : open a cursor and select all the data (say 10,000 rows) ? > > How about > > OPEN cursor ... > FOR i = 1 TO 100 > FETCH ... > END FOR > CLOSE cursor > > John This does the same as the example shown above. Roland