Changing an Access query using VC++

From: DCB (dboneham_at_ngms.eu.com)
Date: 11/22/04 

Date: 22 Nov 2004 06:43:08 -0800

Using VC++ is there a way of getting at the actual SQL command behind
an Access query? I have tried to use ADOX::Catalog->GetProcedures()
but that doesn't seem to include the queries. I can run the query by
passing its name to a Recordset::Open() so I know the queries are
there and work.

Any ideas?

Relevant Pages

  • Conditional Calculations
    ... Queries are the toughest for me. ... Now I am trying to do some calculations in a query based on conditions. ... How can I do above-mentioned *conditional calculation* in an Access query? ...
    (microsoft.public.access.queries)
  • Re: select max value from multiple fields within a record
    ... the funny thing about Access queries is that they expect the data to ... > the vertical comparison feature. ... > that can be done in an Access query without a giant nested IF statement or ...
    (microsoft.public.access.queries)
  • Re: How can I use my queries?
    ... In Access query if I want the user to input parameter I write: ... in project there a no queries at all!! ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Conditional Calculations
    ... Queries are the toughest for me. ... > in an Access query. ... > Syed Zeeshan Haider ... The trick is to figure out how to do it without using the clumsy Iif ...
    (microsoft.public.access.queries)
  • Re: Using SQL Server as the backend
    ... queries I would have had if I were using Access/Jet tables and then I ... Whether that redesign involves just changing the Access query or moving to ... server even when you use plain old queries against the links. ...
    (comp.databases.ms-access)