How can one use multiple recordset in ADO application. I would like to open two or three of the recordsets at the same time.
I would appreciate very much If someone has got a code to offer me. Counting on your co-operation. Thanks.
Albert
Printable View
How can one use multiple recordset in ADO application. I would like to open two or three of the recordsets at the same time.
I would appreciate very much If someone has got a code to offer me. Counting on your co-operation. Thanks.
Albert
There is no problem at all.
If you know how to open one ado recordset then you know how to open multiple recordset.
Just give anyone of them a different name.
I usually set up multiple recordsets in the Data Environment. If you query MSDN on DataEnvironment, you should get a pretty clear explaination of how this is done. Not much coding, just careful clicking.
Good luck.
------------------
Thomas