ADO NextRecordSet

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paul (paul.gamblen_at_pacmicro.com.au)
Date: 06/07/04 

Date: 7 Jun 2004 02:20:39 -0700

Hi

Im executing multiple SQL statements within a batch (using ADO) and
using the ADO NextRecordset method to loop through the returned
results. Im actually expecting some of the SQL statements to error for
one reason or another, however when I call NextRecordset after I have
retrieved information about the error, there are no more recordsets to
retrieve (i.e NextRecordSet returns nothing), even though the rest of
the statements have actually executed (i.e. I can tell that my updates
and inserts have gone ahead). Can anybody help with this problem? I
guess what Im looking for is something very similar to what Query
Analyser achieves (i.e. still getting all the Messages and Resultsets
about the batch that was executed whether there was an error or not),
can this be done with ADO?

Hope someone can help,
Paul.

Relevant Pages

  • Re: ADO NextRecordSet
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > using the ADO NextRecordset method to loop through the returned ... Im actually expecting some of the SQL statements to error for ... however when I call NextRecordset after I have ...
    (microsoft.public.sqlserver.programming)
  • Re: Relationship Question
    ... I've used your SQL statements by passing them into an connection.Execute ... statement in ado. ... CONSTRAINT master_cannot_be_slave ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Application Error 1000
    ... that since you application uses DSN, ADO will use OLEDB for ODBC between ADO ... > The last event that oLog writes is 'Executing' + the SQL statement. ... > is written to the log file. ... >>> We used the vb6 installation tool to make a Setup. ...
    (microsoft.public.vb.database.ado)
  • Use of WITH XMLNAMESPACES
    ... When executing a query to obtain XML data from an XML column I know ... that every SQL Statement I am executing uses the namespace. ... Then I can just issue any number of SQL Statements and they ...
    (microsoft.public.sqlserver.xml)
  • Re: running out of memory
    ... First of all it is not ADO, ... using of the SQL statements on a server side inside of SP to do this rather ... > I've found that looping through an ado recordset will cause memory ... > if it's a large recordset. ...
    (microsoft.public.dotnet.framework.adonet)