Different Queries with Recordset
I'm working with a Data Base and I'm using ADOR recordset.
I would like to know if after to open the recordset with the following parameter
(rs_pp.Open “Select * from my_tableâ€, “my_BDâ€)
I can to make another query without to close the recordset.
Can I make different queries into the same table with the same recorset?. The queries, logically, would be in different time.
If this subject is possible how can I make it?
Thanks for your help......
Re: Different Queries with Recordset
a recordset object IS the records you get from a query. the only way u can use the same object for few recordsets, is to use:
set rs_pp=new ador.recordset
everytime before u call '.open'