Create Recordset

[Tonatiuh]

Can I create (open) a recordset not from a table, from another recordset in memory instead? Something like this:


'open recordset 1
rs1.Open "SELECT * FROM table",cn... (etc)
'open recorset 2 from the first recordset
rs2.open "SELECT * FROM rs1,... (etc)

[Ianpbaker]

Hi Tonatiuh

do you mean you want requery the data that has been returned in the first recordset?

Ian

[Tonatiuh]

Yes Ian, the tables where I get the rs1 are too big and slow, and the net is elittle slow in some cities. I think if this is posible (create rs2 from the rs1) it must be to much quickly because the rs1 is already in memory.

[Ianpbaker]

As far as I know, you have to use a connection object to open a recordset but moving through a recordset in VB checking whether a certain criteria matches the record's that have all ready been retured is very quick

Ian

I have no idea how to work with a second recordset.
I suggest to copy rs1 to an array and work from there....

[Tonatiuh]

Ther is not very quick when the recordset is too much large and contain many fields.