How to copy one record set to another in VB

Asked Nov 27 '14 at 12:09

Active Nov 27 '14 at 12:09

Viewed 664 times

I have a record set, I want to copy its data to another record set.

Dim rsAttributes,LoggedInUserId,rsAttributes1
Set rsAttributes = Server.CreateObject("ADODB.RecordSet")
Set rsAttributes1 = Server.CreateObject("ADODB.RecordSet")
Set rsAttributes = CALL DB TO GET DATA.

Now How can I copy rsAttributes value/data to rsAttributes1 . I tried with CLONE method, but did not work.

asked Nov 27 '14 at 12:09

user1926138

1,238
7
25
50

Is this *VBScript* + *Classic ASP*? - [Deep Copy or Clone an ADODB recordset in VBA](http://stackoverflow.com/questions/25553594/deep-copy-or-clone-an-adodb-recordset-in-vba) (Removing the `as `) – Alex K. Nov 27 '14 at 12:12
Not working for me :( – user1926138 Nov 27 '14 at 12:44
"Not working for me" isn't very helpful when you want the advice – Rob Nov 28 '14 at 12:26

How to copy one record set to another in VB

0 Answers0