I STRONGLY disagree with the assertion that "it generally doesn't work" when
using strings in WHERE clauses in Pro*C. I have been using them for years
with absolutely no problems. You just have to make sure that you use
VARCHARs rather than simple character strings unless you know for certain
that the database column you are comparing against is always a constant
length.
Larry Brendler
"Terry Steyaert" <steyaert_at_my-deja.com> wrote in message
news:8bdmlp$9r4$1_at_nnrp1.deja.com...
> <Orignal cut for band-width sake.>
>
>
> Overall, we have always had problems during selects based upon
> strings. Our ultimate fix, from Oracle 6 on, has been to space fill
> the strings to a set length. This seems to clean up the problems that
> we have had doing exactly what you are doing. If your database column
> is filled to 20 characters, and your string is filled to the 20
> characters, it will work fine. If they are not, it generally doesn't
> work.
>
> If you can manage it, do your selects based upon integer or number
> columns as they are much more reliable than strings. With our space
> fills, I don't get the errors that you are seeing, but before we space
> filled, occationally strange errors would occur.
>
> Terry Steyaert
> steyaert_at_my-deja.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Mar 24 2000 - 09:29:04 CST