• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

Copying an entire RDO resultset

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
yronnen
Asked:
yronnen
1 Solution
 
jmnolanCommented:
Can you dim a new recordset and use the clone method? Something like this perhaps?

Dim recNewRecordset as Recordset
Set recNewRecordset = recOldRecordset.Clone
0
 
yronnenAuthor Commented:
This is good for a recordset. I'm using a resultset that do not have the clone method
0
 
mukvijCommented:
dim rsOld as rdoResultset
dim rsNew as rdoResultset
Set rsOld= OpenResultset.....Whatever sp
Set rsNew = rsOld
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
yronnenAuthor Commented:
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
 
mukvijCommented:
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
 
mayhewCommented:
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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now