[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::odbc_rdb_driver

Title:DEC ODBC Driver
Notice:DEC ODBC Driver V2.0 Now Available
Moderator:SQLSRV::MAVRIS
Created:Tue Dec 29 1992
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1357
Total number of notes:4864

1323.0. "Like giving random results" by ORAREP::EVTSG8::TOWERS () Wed Apr 02 1997 08: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
T.RTitleUserPersonal
Name
DateLines
1323.1148.87.13.1::EKREISLEErich KreislerThu Apr 10 1997 09:2310
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
1323.2ORAREP::EVTSG8::TOWERSThu Apr 10 1997 12:059
    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