Re: UPPER and memo fields

Article View: borland.public.vdbase.data.sql

Article #1373

Back to borland.public.vdbase.data.sql Previous Next

#1373

From: Ken Chan
Date: Thu, 12 Feb 1998 00:00

19 lines
1181 bytes

Romain Strieff [TeamB] wrote:

> Yeah, but the question is, will UPPER() be fixed in the inline so that it 
> works or do we have to tell the client that they need to buy Interbase 
> Licences for a couple of thousand $ if they want to search a memo field 
> with their flashy new 32 bit application. 

I believe it's actually a different SQL predicate. You can't use UPPER() 
in the WHERE clause like that.

> CanGetRow is a joke on every table with more than a ten thousand records.

It's no worse than a SET FILTER statement. I had no idea it was so funny 
all these years.

-- 
//Ken[0]@Borland
<Please follow-up to newsgroup; do not reply to email>

Technical Details

Message-ID: <MPG.f4d6be1c040cbb89897fb@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<6b4qs9$51q10@forums.borland.com> <MPG.f4a8561a1ec34399897e5@forums.borland.com> <MPG.f4b858b2f3e68ce98a6b4@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,efb4658663119c4a
X-Google-Attributes: gidff5a1,public
From: supportinfo@borland.com (Ken Chan)
Subject: Re: UPPER and memo fields
Date: 1998/02/12
Message-ID: <MPG.f4d6be1c040cbb89897fb@forums.borland.com>
X-Deja-AN: 324648004
References: <6b4qs9$51q10@forums.borland.com> <MPG.f4a8561a1ec34399897e5@forums.borland.com> <MPG.f4b858b2f3e68ce98a6b4@forums.borland.com>
Organization: Borland
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message