Subject Re: [firebird-support] Proper way for copy data from big table
>>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

Thanks you very much Mark,
I'm forgotten about forward only – and i have used buffered dataset

This does the trick

Karol Bieniaszewski

[Non-text portions of this message have been removed]