Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Copying an entire RDO resultset

Posted on 1998-12-29
6
Medium Priority
?
331 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

597 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