Copying an entire RDO resultset


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).
Who is Participating?
mukvijConnect With a Mentor Commented:
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
Can you dim a new recordset and use the clone method? Something like this perhaps?

Dim recNewRecordset as Recordset
Set recNewRecordset = recOldRecordset.Clone
yronnenAuthor Commented:
This is good for a recordset. I'm using a resultset that do not have the clone method
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

dim rsOld as rdoResultset
dim rsNew as rdoResultset
Set rsOld= OpenResultset.....Whatever sp
Set rsNew = rsOld
yronnenAuthor Commented:
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.
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.