| 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 |
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.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1323.1 | 148.87.13.1::EKREISLE | Erich Kreisler | Thu Apr 10 1997 05:23 | 10 | |
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.2 | ORAREP::EVTSG8::TOWERS | Thu Apr 10 1997 08:05 | 9 | ||
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
| |||||