Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ADODB.Recordset

Posted on 1999-06-28
4
Medium Priority
?
165 Views
Last Modified: 2013-12-25
How can I copy a recordset returned by [ADODB.Connection].Execute to another recordset ?

Andrew
0
Comment
Question by:andrewyu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 2

Accepted Solution

by:
nikhilh earned 0 total points
ID: 1834805
Use the method "Clone" of the recordset object
0
 

Author Comment

by:andrewyu
ID: 1834806
Thank you very much !

Is it "Set rsclone = rsoriginal.Clone" ?

Andrew
0
 

Author Comment

by:andrewyu
ID: 1834807
When I try "Set rsclone = rsoriginal.Clone", I get a error as follow, why ?

ADODB.Recordset error '800a0cb3'
The operation requested by the application is not supported by the provider.

Andrew

0
 

Author Comment

by:andrewyu
ID: 1834808
The code segment is listed below !


set con = Server.CreateObject("ADODB.Connection")
con.Open "DSN=database;uid=username;pwd=password;"
Set rs = con.Execute("select id, name from table")
Set rs1 = rs.Clone


Andrew
0

Featured Post

The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this tutorial I will show you how to make a simple HTML bar chart with the usage of WhizBase, If you want more information about WhizBase please read my previous articles at http://www.experts-exchange.com/ARTH_5123186.html (http://www.experts-ex…
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question