Re: use command set sqlcase upper from within VB 6.0 app ?

From: <cgrandy_at_disc.com>
Date: Tue, 30 Jan 2001 16:11:25 GMT
Message-ID: <956p35$7rr$1@nnrp1.deja.com>

OMNIDEX can enhance Oracle to give you case-insensitive searches. See http://www.disc.com/keyword.html or contact me.

Cheryl Grandy
cgrandy_at_disc.com

In article <eido6t0khgog05bcijrlgevk01lgmtqa46_at_4ax.com>, Bernd Rosenau <brosenau_at_gss-online.de> wrote:
> Hi,
>
> our VB 6 application uses ADO to access tables on a Oracle 8 server.
> Our clients are asking for case insensitive searching.
>
> I found out that one can switch this feature on with the command SET
> SQLCASE UPPER but this seems only to work within SQL PLUS.
>
> Is there a way to make the setting SQLCASE UPPER valid for the whole
> Oracle server and therefore for my VB 6 program or is there a way to
> set SQLCASE to upper by using ADO ?
>
> Many thanks in advance
>
> Cheers Bernd
>
>

--
Cheryl Grandy
DISC
Get OMNIDEX for the fastest
applications ever


Sent via Deja.com
http://www.deja.com/

Received on Tue Jan 30 2001 - 10:11:25 CST