If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Does SQL Run Behind Queries?
Access 2007
When I run a query does Access, "go away" and run the SQL for what I see in the GUI? If the answer is, "yes" is there anything that I can switch on to see the SQL that it is running? What I would like to do, if it is possible, is to see the query in the GUI and, at the same time, see the SQL that is being used to select the data from the database; that way I can understand things (exactly what is happening) more clearly and more quickly. TIA for any replies. |
#2
|
|||
|
|||
Does SQL Run Behind Queries?
Rick, many thanks.
"Rick Brandt" wrote: trip_to_tokyo wrote: Access 2007 When I run a query does Access, "go away" and run the SQL for what I see in the GUI? If the answer is, "yes" is there anything that I can switch on to see the SQL that it is running? What I would like to do, if it is possible, is to see the query in the GUI and, at the same time, see the SQL that is being used to select the data from the database; that way I can understand things (exactly what is happening) more clearly and more quickly. TIA for any replies. Queries have three view options. Datasheet Design SQL There is no option to see the last two at the same time, but you can certainly look at the SQL. . |
#3
|
|||
|
|||
Does SQL Run Behind Queries?
On Sat, 5 Jun 2010 03:39:06 -0700, trip_to_tokyo
wrote: Access 2007 When I run a query does Access, "go away" and run the SQL for what I see in the GUI? If the answer is, "yes" is there anything that I can switch on to see the SQL that it is running? What I would like to do, if it is possible, is to see the query in the GUI and, at the same time, see the SQL that is being used to select the data from the database; that way I can understand things (exactly what is happening) more clearly and more quickly. TIA for any replies. The SQL *IS* the query. The GUI is not the query; it's a tool that makes it easier to construct SQL. You can view the query in the GUI or in SQL, toggle back and forth, look at either one. You can't see the SQL "while the query is running" though, as far as I know, if you mean in the same window. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Does SQL Run Behind Queries?
trip_to_tokyo wrote:
Access 2007 When I run a query does Access, "go away" and run the SQL for what I see in the GUI? If the answer is, "yes" is there anything that I can switch on to see the SQL that it is running? What I would like to do, if it is possible, is to see the query in the GUI and, at the same time, see the SQL that is being used to select the data from the database; that way I can understand things (exactly what is happening) more clearly and more quickly. TIA for any replies. Queries have three view options. Datasheet Design SQL There is no option to see the last two at the same time, but you can certainly look at the SQL. |
Thread Tools | |
Display Modes | |
|
|