>>For example in Java the default result set is forward only. If it doesn't >>have rows, it will fetch a number (default is 400 in Jaybird), this is done >>through a fetch. It will then serve requests for rows from the application >>from this retrieved set of rows. When it needs more, it discards the old >>set rows and fetches the next set. This ensures that memory is not >>exhausted (assuming the application itself doesn't hold on to the retrieved >>info).
>>Mark Thanks you very much Mark, I'm forgotten about forward only – and i have used buffered dataset This does the trick regards, Karol Bieniaszewski [Non-text portions of this message have been removed]
