?
Solved

Copying an entire RDO resultset

Posted on 1998-12-29
6
Medium Priority
?
330 Views
Last Modified: 2013-12-25
Hi,

I have an RDO resultset that is coming back from a stored procedure.

how can I duplicate it? I mean, I want to have two identical result sets in memory (not two pointers to the same resultset).
0
Comment
Question by:yronnen
[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
6 Comments
 

Expert Comment

by:jmnolan
ID: 1498583
Can you dim a new recordset and use the clone method? Something like this perhaps?

Dim recNewRecordset as Recordset
Set recNewRecordset = recOldRecordset.Clone
0
 
LVL 5

Author Comment

by:yronnen
ID: 1498584
This is good for a recordset. I'm using a resultset that do not have the clone method
0
 
LVL 1

Expert Comment

by:mukvij
ID: 1498585
dim rsOld as rdoResultset
dim rsNew as rdoResultset
Set rsOld= OpenResultset.....Whatever sp
Set rsNew = rsOld
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 5

Author Comment

by:yronnen
ID: 1498586
Sorry,
I've tried this method first, but the two pointers always show the same records.
I need to be able to point on different records.
0
 
LVL 1

Accepted Solution

by:
mukvij earned 200 total points
ID: 1498587
I understand our problem but I have used the same thing and have used bookmarks and was able to serve my purpose. See bookmarking if it helps
0
 
LVL 5

Expert Comment

by:mayhew
ID: 1498588
I realize that it would increase traffic, but would it serve your purposes to just make two calls to the proc?

rsFirst = OpenResultSet...
rsSecond = OpenResultSet...

Just a thought.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses
Course of the Month10 days, 12 hours left to enroll

765 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