Link to home
Start Free TrialLog in
Avatar of andrewyu
andrewyu

asked on

ADODB.Recordset

How can I copy a recordset returned by [ADODB.Connection].Execute to another recordset ?

Andrew
ASKER CERTIFIED SOLUTION
Avatar of nikhilh
nikhilh

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of andrewyu
andrewyu

ASKER

Thank you very much !

Is it "Set rsclone = rsoriginal.Clone" ?

Andrew
When I try "Set rsclone = rsoriginal.Clone", I get a error as follow, why ?

ADODB.Recordset error '800a0cb3'
The operation requested by the application is not supported by the provider.

Andrew

The code segment is listed below !


set con = Server.CreateObject("ADODB.Connection")
con.Open "DSN=database;uid=username;pwd=password;"
Set rs = con.Execute("select id, name from table")
Set rs1 = rs.Clone


Andrew