viewing ADO data with changing recordset

[fkauffman]

Hi,

In applications like MSAccess, when you open a large database you can scroll through the first retrieved records while the other records are being loaded.
This is what I would like to make in my application.

At this moment my application:
- divides the database in parts (using recordcount)
- creates a new recordset
- gets the first part of the database (recordsetX)
- appends this records to my new recordset
- gets the second part of the database
- appends this records to my new recordset
- gets the third p.......

But how do I present this records to my user?

(I tried to use a datagrid, that I connected to my recordset, but when I do a recordsetX.movelast also the datagrid moves to the last record.
I don't know why because in my opinion this recordset isn't connected to my datagrid)

all ideas welcome,

Fedor

[JHausmann]

I have no idea why you'd want to go thru all this grief but you could load the data into a collection, copying from multiple recordsets...

[fkauffman]

Thanks, but.. I don't know exactly what you mean. Could I copy multiple recordsets into a collection and use the collection to browse the data?

Fedor

And is my idea really strange? I'm probably running in circles, because I can't think of another solution to present data from a large database to my user.
(Any other ideas are welcome, I getting pretty disappointed by this one)

[Clunietp]

just fetch your results asynchronously