Results 1 to 4 of 4

Thread: SQL on In-Memory Recordsets [resolved]

Threaded View

  1. Oct 13th, 2003, 10:44 AM #1
    Negative0
    Negative0 is offline

    Thread Starter
    PowerPoster 2.0 Negative0's Avatar
    Join Date
    Jun 2000
    Location
    Southeastern MI
    Posts
    4,367

    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,
    Last edited by Negative0; Oct 13th, 2003 at 01:16 PM.
    Negative 0

    Blog | RegEx | Encrypting UN/PW in Web.Config | Enabling ASP.Net on IIS 6 | Port Numbers | Creating GUIDs | Start->Run | Modifying the default class



    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width