Toying about with SQL, and just wondering

Goodday fellow-listers,

I am toying about with SQL, just because I am not too familiar with SQL
as a database I/O method and I want to gain knowledge on this area.
During this I was playing about with the various parts that can be
filled by file I/O: header part, main screen and subfile. Now I think I
have the idea about preparing statements and executing them, and even
the part in which you 'connect' them to a cursor. But then I wondered:
say that a file would produce a large result set (for the sake of
argument: 1.000.000 rows), and I wanted to fill a subfile with just 10
rows at a time; do I have to wait until all 1.000.000 records have been
placed in the result set before I can begin building the subfile? Or is
it possible to fill the resultset with, say, 100 records at a time and
continue this 'at will'?


Kind regards,

Cor Takken



This e-mail and any attachment is for authorised use by the intended 
recipient(s) only. It may contain proprietary material, confidential 
information and/or be subject to legal privilege. It should not be copied, 
disclosed to, retained or used by, any other party. If you are not an intended 
recipient then please promptly delete this e-mail and any attachment and all 
copies and inform the sender. Thank you.