Search results for query: *

Thanks everyone for your responses and analysis. I'm going to try cmmrfrds's suggestion to reorder the tables in the from clause to match the query2. Indeed, CD_VIEW is the largest of the 3 views. I'm connecting to the Oracle database using Oracle ODBC Driver 8.01.76. It looks like I just...

Ignacious, Not sure if I understood your question but you may try these selects. Count for Item1: select count(FieldName) from yourTable where FieldName=Item1 group by FieldName Count for Item2: select count(FieldName) from yourTable where FieldName=Item2 group by FieldName Hope this...

Thanks everyone for the reply. Thanks cheerio for the explanation why the sql pass through query should run faster. In response to the question as to what server I'm sending my sql pass through query, it is to an Oracle database - Documentum. Here is the sql pass through query: SELECT...

Hi, Are there cases when a regular SELECT query would run faster than if it were run as sql pass through query? If so what are those cases? I have a query that has 2 outer joins was originally designed as sql pass through query. It ran for over 4 minutes but when I converted it to an SELECT...

Thanks to all your responses. I have gone to the Oracle forum, but after some testing last night, I realized that the SQL Pass-Through query was not the one running slow but the fact that my application is running the query as a regular SELECT query. The application is running it as a SELECT...

Thanks Duane. I tried but it is still running slow. In fact, half an hour had passed and it was still running. By change you have other suggestions? --mlz

Hi, I am trying to improve the performance of a SQL Pass-Through query that supposed to retrieve two sets of data: 1) Newly added documents 2) Newly added change documents The query below executes under 5 minutes for small number of records that are being compared. But it runs for half an...

Thanks John. Your solution worked ! --mlz

Hi, Is there a way I can set the ODBC Connect STring property of a sql pass-thru query at startup of the application, or before the user executes the sql-pass thru query ? Background: Currently, I have over 10 reports whose recordsources are sql pass thru queries. Presently, when the user...

Hello, I'm resending my question sent on Nov 6th. Does anyone has some suggestions? Thanks, mlz

Hi there, Please try this: 1. Add a text box field in your report layout. If you want the sum to appear for a group, then add the text box in that group's footer section. If you need to show the sum at end of the report, i.e. grand total,then add the text field in the report footer section. 2...

Hi, In preparation for a database change, I'm modifying a sql-pass through query to use a new ODBC Connection string. When executed in sqlplus, the same query successfully returns records. But when executed in ACCESS97 and with Oracle ODBC driver 8.01.76, the query would fail and display the...

Hi, We have a MS-ACCESS db application that uses Sqlpassthru queries to retrieve data from an Oracle (8.1) database. This application's user population has grown and managing the manual setting up of DSN on the user's workstations is becoming inefficient. I've tried to find threads and FAQs...

Hi lbass, Thanks for your reply. Tried your suggestion but I get an error "Summary/running total field could not be created.". Maybe I've missed a step. Please advise. I also want to add to my problem description. I need to display the actual fields in the records that are the...

Hi, I'm fairly new to CR 8.5...Need to write a report that shows the difference between 2 sets of data: set 1 : data from yesterday set 2 : data from today The fields from these 2 sets are the same. I need to show the records that were in set 2 but not in set 1 and vice-versa. Would a...

Thanks much for the answer and for the thread333-549689 that showed how to find out my VBscript version. We have an older version. mlz

Hi, I'm trying to use multiline method of RegExp and am getting an error: Object doesn't support this property or method: 'regExpCR.Multiline' What is the cause of this error? Please help. Thanks, mlz

Hi, I'm trying to write a query that updates a table that I'm accessing via a database link. I tried writing it as a SQL Pass Through query but MS ACCESS gives an error that says "may not perform insert/update/delete operation inside a READ ONLY transaction". My query looks something...