Conference orarep::nomahs::odbc_rdb_driver

1323.0. "Like giving random results" by ORAREP::EVTSG8::TOWERS () Wed Apr 02 1997 05:18

    I'm having problems with a search. I'm using SQL code which looks like:
    Select * from Products where DECPartNo like 'AA-AAAAA-%'
    If I have part number AA-AAAAA-A0 thru' AA-AAAAA-A9 then I seem to get
    random results.

    If I search for DECPartNo like 'AA-AAAAA-A0' then it works. If I try 
    variations like 'AA-aaaaa-%' or 'AA-%-a1' then I can get into a state
    where it fails to find anything some of the times but not others.
    If I set logging on then it just annoyingly always works.

    This is with VB4, Oracle RDB ODBC v2.10.11 on a Windows 95 machine
    and RDB v6.1.

    Does anybody have any ideas?

    Cheers,
    Brian

Your problem is with upper and lower case for example
'AA-AAAAA-%' is not the same as 'AA-aaaaa-%'.
.
On the other side what do you mean by 'random results ? Do you get too many
rows? What else ?

Do want to say that it works when enabling logging that you get the correct
results or does the comparison from above work ?

erich

    By random results I mean that sometimes 'AA=aaaaa-%' works and
    sometimes it doesn't.
    
    When logging is enabled then 'AA-aaaaa-%' always works. That is to say
    it always finds the part. Is there some case-sensitive flag that is
    affected by this somewhere?
    
    Cheers,
    Brian