Oracle criteria problem

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

 

[Douglas J. Steele]

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.