Re: ADO Shape and Subqueries

From: James (See.My.Sig_at_The.Bottom.com)
Date: 02/19/05 

Date: Sat, 19 Feb 2005 04:35:04 GMT

i need to do this also. how would you reference the previous recordset in
the second recordset, since you suggest making two recordsets insted of
doing this in one. My reasoning for neededing a shape clause that includes
the same table is because i want to create a hiararchial tree of Employees
and there Managers. is this the right direction for me to be researching to
solve my problem?

"Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom> wrote in message
news:uX2DRufFFHA.3336@TK2MSFTNGP10.phx.gbl...
>> 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: Record Select question
    ... that loops through a recordset looking for events that need to be activated. ... looping through a recordset instead of executing a delete query. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Unexpected Access 2000 query results
    ... looping through a recordset and inserting rows. ... executing a query that selects the total of the previous two records that ... This query comes up empty. ...
    (microsoft.public.data.ado)
  • Re: ADO Shape and Subqueries
    ... Is this subquery executing at the same time as the query is? ... cursors working off the same connection at the same time. ...
    (microsoft.public.data.ado)
  • Re: Need Help to Control the UDF from re-calculation
    ... Looks like the time is being used making the connection and executing the ... query to get the recordset. ... I would suggest that you get the complete recordset (without the filters, ...
    (microsoft.public.excel.programming)
  • Re: Query based on the results of another query?
    ... About the only option you would have would be to construct a new query ... dynamically in code from the recordset you alread have. ... not be as efficient as executing a new query. ...
    (borland.public.delphi.database.ado)