Re: Command Object Output Parameter Undefined?

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

On Thu, 5 Oct 2006 10:11:03 -0400, "Bob Barrows [MVP]" wrote:

[...]
My SOP is to use GetRows to stuff the data from the recordset into an
array, close the recordset, then retrieve the output and return
parameter values, allowing me to immediately close the connection before
starting to process the data.

An alternative is to use client-side cursors in ADO. This is
particularly useful if you use a single stored proc call to return
parameters and multiple recordsets. No messing with arrays.
--
Ross McKay, Toronto, NSW Australia
"Let the laddie play wi the knife - he'll learn"
- The Wee Book of Calvin
.

Relevant Pages

  • Re: GetRows Method
    ... The performance benefit that's talked about has to do with how long it takes ... as well as time to retrieve the fields once. ... then you're better off using the recordset as is. ... data, etc, then consider using GetRows, as that's its main performance ...
    (microsoft.public.vb.database.ado)
  • RE: Error 3021
    ... The only thing I see is that after you open the recordset, ... Create proto-file names using the selected job names and storre to an array ... Save and close the document and repeat the loop ...
    (microsoft.public.access.modulesdaovba)
  • Re: Best way to populate a <SELECT>
    ... Use .GetRows() to return an array from your recordset. ... GetRows array into a routine that writes your ...
    (microsoft.public.inetserver.asp.db)
  • Re: Passing Recordset to a Form
    ... Siteand Count which is the array length. ... to my recordset, but not into my database table. ... Dim rstview As adodb.Recordset ...
    (microsoft.public.vb.database)
  • Re: How to make fetching and displaying of data from dtabase to workbo
    ... It actually imports at lightning speed ... ... I need to get data from the database and display in the excel sheet. ... Make a temporary array and while moving through the Recordset data ...
    (microsoft.public.excel.programming)