Oracle criteria problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The firm I'm consulting at uses Access 2000 FEs to an Oracle 8 data warehouse.

I'm having trouble with a (native Access) query of joined Oracle tables
using a text value from a displayed combo box column, not the bound column,
as part of the query criteria, not a pass-through query. I know, I know. but
I've inherited it all.

The query is a complex join of several linked Oracle tables.

The query returns nothing. When I filter using specific string characters
from the combo box column or a pure text criteria, the query returns data
correctly.

Example which doesn't work:
Query column: State ("NY" is a value in the recordsource)
Query column criteria: Forms!frmX!cboY (having a value of "NY")

However, the following works:
Query column: State: Left([TableName].State,2)
Query column criteria: Left(Forms!frmX!cboY,2)
and
Query column: State
Query column criteria: "NY"

I can't figure out what's going on. Is this an Oracle profile issue?

Thank you in advance for your comments.
 
How are the fields defined in Oracle? I've got virtually no experience with
Oracle, but I know that Char fields in SQL Server are padded with blanks, so
that you need to use the Trim function, the Like operator, or Left as in
your example.
 
Back
Top