CODEWITHSUNDEEP
ms-accessodbcoracle11g
user1450731
user1450731

Reputation: 49

Access mdb not giving correct result

I am using Access(2003) mdb file as front end of oracle 11g R2 as backend. I am using odbc connection to retrieve data from oracle database. But sometime mdb is displaying incorrect output.

For example, when I use the below query in mdb 

SELECT *
FROM PLAN 
WHERE (((PLAN.BATCH_REF)="SSU080520122"));

and it is providing wrong result. But the same query is providing correct result in oracle.

Any help will be appreciated.

Upvotes: 4

Views: 326

Answers (1)

HansUp
HansUp

Reputation: 97131

PLAN is a reserved word. Using reserved words as table or column names can confuse the db engine. Although this may not actually be the source of your trouble, it would be easy to rule it out as a contributor. See if you get the results you expect with this query:

SELECT *
FROM [PLAN] AS p
WHERE p.BATCH_REF="SSU080520122";

Upvotes: 1

Related Questions