SQL on In-Memory Recordsets [resolved]

I have some in-memory only ADO recordsets in VB6 and I am wondering if it is possible to Execute SQL against this data. The recordsets were created on the fly, so there is no source database to execute the code against.

What I am trying to do is run commands like the ones below against the recordset

"Select * From <this recordset> where ID=75"

"Select Distinct(ID) From <ThisRecordset>"

Thanks for your help,

You cannot execute sql queries against a recordset. Use the different properties that are available - Filter, Find, Seek

Quote:

---

Originally posted by brucevde
You cannot execute sql queries against a recordset. Use the different properties that are available - Filter, Find, Seek

---

I second that.... it would be nice if you could do that..... but, alas, it is not possible.

TG

Thanks guys...

I'll just use the filter and approach the problem from a different angle.