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
|
|||
|
|||
Pass Through queries
Today have I have finally started to work with pt queries, and I have something
occurring, which I don't understand. When I want to edit an append query that uses a pt query as input, or add a pt query to my append query in design view, I have to WWWAAIIITTT. It's as if Access is actually processing the pt query, although I never see the data returned. I mean, everything that SHOULD happen, DOES happen. And I get no errors. It's just that there is this LONG response time, which I just don't get. Is this normal? FE: 2.6GHz P4 OS=XP Pro Access 2000 sp3 BE: AS/400 running DB2, both HW & SW upgraded/updated this past winter NW: Not great, but not that bad, either. Thanks, Tom |
#2
|
|||
|
|||
Pass Through queries
"Tcs" wrote in message
... Today have I have finally started to work with pt queries, and I have something occurring, which I don't understand. When I want to edit an append query that uses a pt query as input, or add a pt query to my append query in design view, I have to WWWAAIIITTT. It's as if Access is actually processing the pt query, although I never see the data returned. I mean, everything that SHOULD happen, DOES happen. And I get no errors. It's just that there is this LONG response time, which I just don't get. Is this normal? Yep. To Access the SQL statement in a PassThrough is just a bunch of text. It has to actually retrieve data from the server when used in the query design grid so the field list can be displayed, DataTypes recognized, etc.. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
Pass Through queries
Ahhh...sorry, I don't understand.
I right click on my query and select Design View. I get a window that is all white except for my code. (Looks similar to Notepad.) The title bar says the query is SQL-Pass Through. If I right click on the title bar to GO/CHANGE to the design grid (like I can do when NOT dealing with a pt query), the "Query Design" selection is grayed out. In any case...Access still has to play with data, eh? No way to turn this off, until I'm "ready" for Access to go get data? On Wed, 11 Aug 2004 13:14:57 -0500, "Rick Brandt" wrote: "Tcs" wrote in message .. . Today have I have finally started to work with pt queries, and I have something occurring, which I don't understand. When I want to edit an append query that uses a pt query as input, or add a pt query to my append query in design view, I have to WWWAAIIITTT. It's as if Access is actually processing the pt query, although I never see the data returned. I mean, everything that SHOULD happen, DOES happen. And I get no errors. It's just that there is this LONG response time, which I just don't get. Is this normal? Yep. To Access the SQL statement in a PassThrough is just a bunch of text. It has to actually retrieve data from the server when used in the query design grid so the field list can be displayed, DataTypes recognized, etc.. |
#4
|
|||
|
|||
Pass Through queries
"Tcs" wrote in message
... Ahhh...sorry, I don't understand. I right click on my query and select Design View. I get a window that is all white except for my code. (Looks similar to Notepad.) The title bar says the query is SQL-Pass Through. If I right click on the title bar to GO/CHANGE to the design grid (like I can do when NOT dealing with a pt query), the "Query Design" selection is grayed out. In any case...Access still has to play with data, eh? No way to turn this off, until I'm "ready" for Access to go get data? I was talking about when you add the PT as an input into another query and that other query is being modified using the query design grid. Let's say your PT query was "SELECT Field1, Field2 FROM SomeTable". If you try to include that PT query as the input into a standard query using the query design grid it will show up in the top of the designer as a rectangle with the two fields "Field1" and "Field2" displayed in it. Access had to send the SQL statement in the PT to the server to get the names and DataTypes of those two fields because there is nothing in the local PT object that tells Access this information. To Access, your PT query has a SQL property, but it is just a bunch of characters. Access cannot parse that statement to figure out the field names because by definition a PT might use a SQL dialect that Access doesn't understand. Even if it was smart enough to parse the SQL to get the names of the fields, it would still have to retrieve from the server information about those fields (like the DataType of each). Does that make sense? -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#5
|
|||
|
|||
Pass Through queries
Oh. OH! Yes, it does now. I should have known realized it, but I just didn't.
Thanks for enlightening me. (Are you sure yesterday wasn't really Friday?) Really, thanks a lot. I appreciate it. On Wed, 11 Aug 2004 16:32:18 -0500, "Rick Brandt" wrote: "Tcs" wrote in message .. . Ahhh...sorry, I don't understand. I right click on my query and select Design View. I get a window that is all white except for my code. (Looks similar to Notepad.) The title bar says the query is SQL-Pass Through. If I right click on the title bar to GO/CHANGE to the design grid (like I can do when NOT dealing with a pt query), the "Query Design" selection is grayed out. In any case...Access still has to play with data, eh? No way to turn this off, until I'm "ready" for Access to go get data? I was talking about when you add the PT as an input into another query and that other query is being modified using the query design grid. Let's say your PT query was "SELECT Field1, Field2 FROM SomeTable". If you try to include that PT query as the input into a standard query using the query design grid it will show up in the top of the designer as a rectangle with the two fields "Field1" and "Field2" displayed in it. Access had to send the SQL statement in the PT to the server to get the names and DataTypes of those two fields because there is nothing in the local PT object that tells Access this information. To Access, your PT query has a SQL property, but it is just a bunch of characters. Access cannot parse that statement to figure out the field names because by definition a PT might use a SQL dialect that Access doesn't understand. Even if it was smart enough to parse the SQL to get the names of the fields, it would still have to retrieve from the server information about those fields (like the DataType of each). Does that make sense? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Slow queries | Michael S. Montoya | Running & Setting Up Queries | 2 | July 23rd, 2004 04:37 AM |
Adding colored font to queries | wbfuga | Running & Setting Up Queries | 2 | July 15th, 2004 02:33 AM |
pass thru queries giving other users result while sorting- Pl help | gdc | General Discussion | 2 | June 25th, 2004 09:14 PM |
Imported Queries & Field Names - Attn S.Clark MVP | Bruce | Running & Setting Up Queries | 3 | June 14th, 2004 12:14 PM |
Exporting Multiple Queries to 1 Excel Workbook with VBA | Anthony | Running & Setting Up Queries | 2 | June 3rd, 2004 07:59 PM |