Re: Restricting queries to a certain number of rows?

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) ? Not if you declare a scroll cursor and use fetch. The scroll cursor will not select all the data into a temporary table like a regular cursor would.