Atze

Hi folks!

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?

Shurik12

Hi,

Unfortunately you can't include a reordset into an sql query.
If for some reasons you don't want create intermediary tables
you could try to write everything in 'one shot', altough wrting such ans sql can be a challenge.

By the way other databases (think of MS SQL and Oracle for example)
have Views and Temporary Table- kind of thing which could come in handy in your case.

And as for your question
>Why i need a SQL-Statment?

The answer is: probably because this language is most suited for these
kind of tasks (no doubts you can achieve the same by using other means
but it would take you more time)

Regards,
Shurik.

Atze

Thx for your reply Shurik12.

Overall i come to the conclusion now, that my problem will only work with physical tables.
Thats how i did it in the past, but i thought that maybe there is another idea somewhere around, what i didn't have seen.

The usage of a SQL-server would not be handy in my case, because it should be a small stand-alone tool.

And my question "Why i need a SQL-Statment?" was not really a question.
It was just a rethoric one, to explain why i want to use a SQL-Statement. But thx for your answer

Regards,
Atze

VBBrazil

Just for clearify something.
Even for a small stand-alone tool, you can use MSSQL in its lite version called MSDE, that is full working and compatible with MSSQL and is free to use.

Atze

@VBBrazil:
Yes, i know about this possibility.
But i especially search for a 'in memory' solution.

I thought that maybe there is something like a wrapper so that i can use the RS as a source for building a new RS with SQL.

Greetings,

Atze

Atze

Hmm, there really seems to be no solution to make a Recordset to the source of a SQL-query...?

Atze

Time has gone by...

Maybe meanwhile there is a solution for this 'topic'?

Or maybe somebody knows, if there is such a possibility in ADO.NET?

Shurik12

I'm afraid not.