Re: ADO Shape and Subqueries

From: Stephen Howe (stephenPOINThoweATtns-globalPOINTcom)
Date: 02/18/05 

Date: Fri, 18 Feb 2005 20:51:03 -0000

> However, when I try the subquery, I get an 'unexpected error'
> when I execute it in code (VB6).

Is this subquery executing at the same time as the query is?
If so, I believe you cannot have 2 server-sided, forwardonly, readonly
cursors working off the same connection at the same time. Change the cursor
properties for one and all will be well.

> If I take the same code and put it in Query
> Analyzer (stripping away the shape related items - they don't work under
> Query Analyzer), it works just fine.

Yes but you are not doing the 2nd query while the 1st has not finished
executing in QA.
You are doing them sequentially in QA, one after the other, and that is the
difference.

I could be mistaken but I believe this is true.

Stephen Howe

Relevant Pages

  • Re: ADO Shape and Subqueries
    ... the second recordset, since you suggest making two recordsets insted of ... > Is this subquery executing at the same time as the query is? ... > cursors working off the same connection at the same time. ... >> If I take the same code and put it in Query ...
    (microsoft.public.data.ado)
  • Re: limiting table access and RWOP queries
    ... your code is not executing a stored query. ... Queries that are executed through code, ... > If I log in as the owner of the table, ...
    (microsoft.public.access.security)
  • RE: Output Query Problem
    ... What is the total record count of the resulting Query? ... having a problem with my VBA code executing when the DB is on the server it ... does not output my query to create an excel file on the server. ... I would get the msgbox "no Data, no report" (an ...
    (microsoft.public.access.modulesdaovba)
  • Re: long running select min(timestamp) query
    ... the query seems to be taking upwards of 10 minutes!!! ... Execution Plan ... You can see if the migrated rows are fixed by ... truncating the CHAINED_ROWS table and executing the same analyze table ...
    (comp.databases.oracle.server)
  • Re: Invalidate cache
    ... I run my queries on a machine that is doing nothing except executing my ... Before every query I execute ... The host machine is only executing VMware. ...
    (comp.databases.ingres)