This is my first post to this brilliant board.
I've a question which is for a long time in my head, and right now i remembered this topic and asked myself if here would be somebody who can help me, or has an idea.
Following situation is given:
I filled an ADO-recordset with some data.
This has been done 'on-the-fly' by some codes. So the data is not existing in any database. It's only in my recordset.
Now i want to use a SQL-Statement to query this data.
One solution i found was that i stored this data in a access-mdb-table and then i could query it.
But this solution caused that i must create files during runtime, what i don't like.
I want to have it just 'in-memory'.
Why i need a SQL-Statment?
For example for grouping the result and having flexible possibilities.
Is there a possibility for this?