ADO Shape and Subqueries

From: Mark (Mark_at_discussions.microsoft.com)
Date: 02/18/05

  • Next message: Stephen Howe: "Re: ADO Shape and Subqueries" 
    Date: Fri, 18 Feb 2005 11:41:02 -0800

    I have an ado shape statement that is working just fine. I want to replace an
    existing column (that is currently returned in a child recordset) with a
    subquery that references two tables that are currently referenced by the
    existing shape. However, when I try the subquery, I get an 'unexpected error'
    when I execute it in code (VB6). 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.

    What is the general construct for a subquery that takes the place of a column?

    Cordially,
    Mark

  • Next message: Stephen Howe: "Re: ADO Shape and Subqueries"

    Relevant Pages

    • Correllated Subquery, unresolving outer references
      ... I'm trying to form a correlated subquery (right now, ... same query against the MS SQL tables directly). ... or a link explaining exactly how to write outer references with MS ...
      (comp.databases.ms-access)
    • too few parameters - Sub Query
      ... I am running a query which references a subquery. ... the criteria in the ... I am receiving the error: ...
      (microsoft.public.access.queries)
    • Re: corelated query
      ... statement, or inside another subquery. ... A subquery that references a column in the outer statement. ... The inner query ...
      (microsoft.public.sqlserver.programming)