Geek Answers Handbook

Access 2007 for Oracle 10g-related table - query with erroneous results, but no errors

Access 2007 databases querying oracle 10g linked tables return erroneous result sets when using the WHERE clause to filter out unwanted records. Oddly enough, some filtering occurs, but not reliably.

I can reliably demonstrate / create the problem as follows:

  • Create a * new * database with Access 2007.
  • Create a second * new * database with Access 2007 and then "save-as" 2000.
  • Create a third * new * database with the old version of Access.
  • Run the following query in each database:
SELECT 
    STATUS, 
    ID, 
    LAST_NAME, 
    FIRST_NAME
FROM 
    Oracle10g_table
WHERE 
        STATUS="A"
  • , Access 2007, , , (STATUS = "A" ) = false, , .
  • , , where , - .
  • STATUS -
  • "" Oracle10g.
  • 68k
  • - 60, 1000 0

- ?

, "" , 2010 . - ODBC?

, - dave

MORE...

, HAVING WHERE, ! , ( - , ), Access 2007, SQL , , WHERE.

0
3

, ODBC. - , , , ODBC ( ), " ", , , . Access 2007.

, , "" , ODBC ( , , ). "Microsoft ODBC Oracle", , , , . WHERE- ().

, . ?:-)

0

, ODBC-, Access Oracle, "A" , "A" . ""? Oracle , "A" ?

Oracle № 1

Select object_name from all_objects
where "OBJECT_NAME" = 'DUAL'

Oracle № 2

with example as (
Select object_name as "Fancy Column Name" from all_objects
)
select * from example
where "Fancy Column Name" = 'DUAL'
+1

. ODBC, " " . - "" .

+1

More articles:


All Articles