Results 1 to 3 of 3

Thread: Recordset question

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Sep 2000
    Posts
    230

    Question

    Is it possible to query against a recordset. Some vendor software I am using exposes a DAO recordset to me, but I want to then filter the already present recordset. In essence, the vendor makes a query and returns to me the result of the query which I can do what I wish. I would like to make another query as opposed to looping through each recordset in the returned set.

    Any suggestions.

    I hate working without source code.
    Shawn Hull
    VB6, SP3 (Professional Edition)

  2. #2
    Hyperactive Member
    Join Date
    Nov 2000
    Location
    Mexico City
    Posts
    306

    Cool

    Instead of a recordset, create a view. A view is like a temporary table made by your query. Then, make a query to your view.

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Sep 2000
    Posts
    230

    hmm, I am not familiar with Views

    I can't say as I have ever seen nor heard the term VIEW, but then again I am not a database guru. Could you explain a little more, pleeeeeease. Or you could direct me to the info. Either way would be good.

    thanks

    Shawn Hull
    VB6, SP3 (Professional Edition)

Posting Permissions

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



Click Here to Expand Forum to Full Width