Printable View
Is it possible for me to create a recordset in memory and perform SQL on it. I need to generate a master recordset and then execute an sql statement and return the new recordset. Is this possible without having to create an actual database file? Thanks
IMDB (in-memory database) was supposed to debut in Windows 2000, but it was removed after RC2 because it didn't support SQL or stored procedures -- I saw a MS powerpoint presentation on that and it looked very cool, but we will see the next version soon.
Anyways, you can create an ADO recordset at runtime, and that recordset will remain in memory. You can also save it to a file and open it later if you'd like....but no SQL statements can be run on it, unless you want to use the Filter and Sort properties, that might help
Edited by Clunietp on 02-24-2000 at 01:57 AM