Fore OpenBase caseInsensitiveLike gets transmogrified to "like" as that is already
case insensitive in OpenBase-land.

The problem to avoid is that often by comparing to "upper(column)" you bypass
any indexes on that column.

The FrontBase and OpenBase plug-ins avoid this in their handling of this query
component.

abc

On Feb 25, 2008, at 12:09 PM, [EMAIL PROTECTED] wrote:

From: Mike Schrag <[EMAIL PROTECTED]>

OK, let me amend my reply. Still waiting for the coffee to brew. :-) Unless the plugin does this, EOF generates Upper(column) = Upper(value).
That excerpt I pasted was from FrontBasePlugIn ...

Yes, but there are other databases...  :-)
Just clarifying -- I couldn't tell if you were responding to my post,
or to the thread in general.

ms



__alex cone
        ceo  c o d e f a b  llc
        [EMAIL PROTECTED]
        212.465.8484 x101
        http://www.codefab.com

If you are not living on the edge, you are taking up too much space.




_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to