Getting a query's SQL statement

  • Thread starter Thread starter Ivan Debono
  • Start date Start date
I

Ivan Debono

Hi all,

How is it possible to get the query's SQL statement using ADO??

Thanks,
Ivan
 
ADOX lists the queries as Tables that are Views or Procedures, and you can
get the CommandText of the Command object.

Much easier to use:
dbEngine(0)(0).QueryDefs("MyQuery").SQL
 
Thanks for tip.

I went with ADOX because I'm doing it in VB. Had to check the Procedures
collection as the query was a UNION. Works great!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error executing sql statement 5
Create INSERT SQL statements 4
How do I execute multiple SQL statements in Access?? 3
A bug in GUI of creating query with more outer joins between two tables 5
Access 2003 Transform Queries?? 9
Calling Parameterized Query Using SQL Syntax 3
Passthrough query 3
Can't use a calculated field in the same SQL code's WHERE clause 3

Back
Top