andrewyu
asked on
ADODB.Recordset
How can I copy a recordset returned by [ADODB.Connection].Execute to another recordset ?
Andrew
Andrew
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
ADODB.Recordset error '800a0cb3'
The operation requested by the application is not supported by the provider.
Andrew
ASKER
The code segment is listed below !
set con = Server.CreateObject("ADODB .Connectio n")
con.Open "DSN=database;uid=username ;pwd=passw ord;"
Set rs = con.Execute("select id, name from table")
Set rs1 = rs.Clone
Andrew
set con = Server.CreateObject("ADODB
con.Open "DSN=database;uid=username
Set rs = con.Execute("select id, name from table")
Set rs1 = rs.Clone
Andrew
ASKER
Is it "Set rsclone = rsoriginal.Clone" ?
Andrew