Re: Copy Data from one ADO recordset to Another ...

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Gunner (gunner_at_docksidesoftware.com)
Date: 07/07/04 

Date: Wed, 7 Jul 2004 10:24:45 -0500

Guess I should have mentioned why I was looking to do this. I have a
recordset created off a Stored Procedure that contains multiple tables, and
hence the recordset is not updatable. I would like to have a detached
recordset that never updates the database, but is updatable and contains the
results from the Stored Procedure.

Thanks

"Andreas Kyriacou" <akyriacou@techplatforms.com> wrote in message
news:u0iUwRDZEHA.2520@TK2MSFTNGP12.phx.gbl...
> I believe all you have to do is declare the second recordset and then:
>
> set rsSecond = rsFirst
>
> --
> Andreas Kyriacou
> Senior Technical Consultant
>
> GoldMine® Certified Professional
> GoldSync® Certified Professional
>
> Technology Platforms Inc.
>
> Bus. (519)584-2447 Ext.208
> Fax. (519)584-2260
>
> Email. akyriacou@techplatforms.com
> Web. http://www.techplatforms.com
> "Gunner" <gunner@docksidesoftware.com> wrote in message
> news:%23aW6rJDZEHA.3596@tk2msftngp13.phx.gbl...
> > Does anyone know of a way to copy all the data from recordset and dump
it
> to
> > another recordset, without iterating through each row in the recordset?
> >
> > Thanks In Advance
> > Gunner
> >
> >
>
>

Relevant Pages

  • Re: using Command to set Parameters and Recordset to retrive the Query
    ... doesn't the rsData will be interpretate as an input parameter in the SP? ... >> Query and retrive the Recordset so I can use the Paging property ... > Even if this technique of using the parameters in the ORDER BY does work for> you, I suspect that this will defeat your objective of preventing sql> injection. ... See below for a more efficient solution> using a stored procedure. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Not Getting results from Stored procedure
    ... So, running a stored procedure from VB6 can be done fairly easily and while there are fewer whitepapers on how to best do so, I thought my website might still have a few but there are not that many left--the problem is, Microsoft is pulling old unsupported content from MSDN so a lot of those links are gone. ... In any event, when calling a stored procedure, you need to include phrase SET NOCOUNT ON, so that the 'records affected' message that occur from results of Stored proc processing aren't returned to the calling application. ... These messages appear to be returned to the calling application as a recordset. ... when calling a stored proc you need ignore the command object and use a syntactically correct string as the source parameter for the recordset's 'Open' method. ...
    (microsoft.public.vb.database)
  • Re: vbscript logon script getting return data from sql sp
    ... Loop ... > One way to retrieve values from a stored procedure is with a Recordset ...
    (microsoft.public.scripting.vbscript)
  • Re: Missing Resultset When Calling an Stored Procedure w/a Nested
    ... we tried advancing to the next recordset by using the NextRecordSet ... program only returned the nested stored procedure call resultset and failed ...
    (microsoft.public.data.ado)
  • Re: Ado Recordset and stored procedure(SQL server 2000)
    ... I want to fill a recordset using a stored procedure. ... inner join track on images.box = track.box where releasetime between ...
    (microsoft.public.vb.database.ado)