Re: SQL Mystery : Bug in latest SQO32_73.DLL?

Tim,

are you sure there are no leading or trailing spaces on T.AGENT? are you sure the
data stored is really '1111' and not '1111' with spaces before the first '1' or after the
last '1'?

try issuing this SQL statement to verify:

    select '^' || T.AGENT || '^'
    from MyTable T
    where T.ID = '059'
    and T.AGENT = 1111;

or this:

    select length(T.AGENT)
    from MyTable T
    where T.ID = '059'
    and T.AGENT = 1111;

i hope this helps.

Romel

Tim Romano wrote in message <354F8E1D.ABE319A2_at_superstream.net>...
>Running Oracle 7.3 Workgroup for NT Server.
>
>MyTable T has these columns:
>
>ID VARCHAR2(3)
>AGENT VARCHAR2(5)
>
>select * from MyTable T
>where T.ID = '059'
>and T.AGENT = '1111'
>
>returns null set. BUT
>
>select * from MyTable T
>where T.ID = '059'
>and T.AGENT = 1111
>
>returns many rows.
>
>Am I missing something very simple? Both columns are
>VARCHAR2.
>Query executed from SQL Plus 3.3. Query also executed from
>TOAD.
>Query also executed from MS-Access via ODBC. All three tools
>yield identical results.
>
>The only thing that has changed on our system was the
>installation today of Oracle's latest ODBC driver for 32-bit
>Windows, and the existing SQO32_73.DLL file was replaced as
>part of the installation.
>
>TIA,
>Tim
Received on Tue May 05 1998 - 22:41:11 CDT