Search results for query: *

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...

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...

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...

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, 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...

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...