• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Re: creating my EOQualifier in code
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Re: creating my EOQualifier in code


  • Subject: Re: Re: creating my EOQualifier in code
  • From: Alex Cone <email@hidden>
  • Date: Mon, 25 Feb 2008 16:46:15 -0800

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@hidden wrote:

From: Mike Schrag <email@hidden>

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@hidden
        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@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: creating my EOQualifier in code
      • From: Alan Ward <email@hidden>
  • Prev by Date: Re: Writing Oracle Blobs under WO 5.4 - WO fails
  • Next by Date: Re: Writing Oracle Blobs under WO 5.4 - WO fails
  • Previous by thread: Re: creating my EOQualifier in code
  • Next by thread: Re: creating my EOQualifier in code
  • Index(es):
    • Date
    • Thread