Hi, I have some queries that produce very large results (several 100.000s) which are too big to be presented to the user (another reason is that it takes a long time to load all the records). So I want to load only a part of it (e.g. 1000 rows) and give the user the opportunity the decide to load the next 1000 rows.
How can I do this? My first idea was to use a WHERE-clause with a rowno--condition, but this way I only get the first part of the result, right? How can I say: Give me the next 1000 rows? Is there a way to do this by SQL? Thanks, Ralf. -- ## Ralf Schneider ## B-connected Linux Solutions GmbH - Linux f�r den Mittelstand ## Dennis-Gabor-Str. 2, 14469 Potsdam ## www.b-connected.de _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
