Thanks... We do have 'CASE OFF' in oterro.cfg and
rbengine.cfg. Yet, for some reason the query fails to find a record when
there's a case mismatch. Yet, doing the same query from MS Query / Excel,
it works and finds the record. So I am guess there might be an option that
can be sent as part of the connect string?
Radi
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Buddy
Sent: Monday, January 30, 2006 9:27 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Case Insensitive ODBC/Oterro Queries
Radi
Check your Oterro.CFG file and make sure
CASE
OFF
Buddy
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Radi Shourbaji
Sent: Monday, January 30, 2006 12:00 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Case Insensitive ODBC/Oterro Queries
Sent: Monday, January 30, 2006 12:00 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Case Insensitive ODBC/Oterro Queries
I need to find a way
to query an RBase database via ODBC/Oterro that is case insensitive.
i.e. evaluates SELECT * FROM users WHERE user = 'jdoe' would select records with
either jdoe or Jdoe as the value.
Any help is
appreciated!
Thanks!
Radi
