\r\n\r\n
Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > Database and Reporting > How can i query a ADO-Recordset with SQL?


\r\n \r\n
 
 
Thread Tools Display Modes

\r\n\r\n\r\n
Hi folks!
\r\n
\r\nThis is my first post to this brilliant board.
\r\n
\r\nI\'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.
\r\n
\r\nFollowing situation is given:
\r\nI filled an ADO-recordset with some data.
\r\nThis has been done \'on-the-fly\' by some codes. So the data is not existing in any database. It\'s only in my recordset.
\r\n
\r\nNow i want to use a SQL-Statement to query this data.
\r\nOne solution i found was that i stored this data in a access-mdb-table and then i could query it.
\r\nBut this solution caused that i must create files during runtime, what i don\'t like.
\r\nI want to have it just \'in-memory\'.
\r\n
\r\nWhy i need a SQL-Statment?
\r\nFor example for grouping the result and having flexible possibilities.
\r\n
\r\nIs there a possibility for this?
\r\n \r\n\r\n
\r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n
\r\n \r\n \r\n \r\n \r\n Reply With Quote\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n \r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n'; pd[445373] = '\r\n\r\n \r\n\r\n
\r\n
\r\n
\r\n\r\n
\r\n \r\n\r\n\r\n\r\n\r\n\r\n \r\n\r\n\r\n\r\n \r\n
\r\n
\r\n  \r\n #2  \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n
\r\n \r\n Old\r\n \r\n 07-26-2003, 04:48 AM\r\n \r\n \r\n \r\n
\r\n
\r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n
\r\n \r\n Shurik12\r\n Shurik12 is offline\r\n\r\n\r\n
Prev Previous Post   Next Post Next
  #1  
Old 07-26-2003, 01:52 AM
Atze Atze is offline
Regular
 
Join Date: Jul 2003
Posts: 85
Default How can i query a ADO-Recordset with SQL?


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?
Reply With Quote
 


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
recordset not receiveing any values from SQL query sunspirits Database and Reporting 6 06-17-2003 02:54 PM
SQL / ADO - Recordset not Updating ebtsup Database and Reporting 2 04-19-2003 09:08 AM
Problem with writing Twice Renidrag Web Programming 20 11-07-2002 02:52 PM
Creating Access Databases TomGuy Database and Reporting 8 07-10-2002 10:56 AM
How to compare an empty value in a query.. pragash Database and Reporting 1 10-22-2001 11:12 PM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->