OpenEuphoria

Re: Quick EuSQL Question (Matt?)

• Posted by Matt Lewis <matthewwalkerlewis at gmail.com> Apr 17, 2006
• 566 views

cklester wrote:
> 
> Matt Lewis wrote:
> > cklester wrote:
> > > Is there a search provision in EuSQL? That is, if I want to search for a
> > > term
> > > in a particular record's field data, can I do it? :)
> > You mean like:
> > 
> > all_recs = run_sql( "select * from my_table where my_field like '*" &
> >                     TEXT_TO_FIND & "*'" )
> 
> Clever! :P
> 
> Thanks. :)
> 
> (Oh, how do I make it case insensitive?)
> 

There isn't currently a way to do this.  Basically, it would probably 
require that UCASE/LCASE functions be added to texteval.e, and integrated
into eusql.  An alternative work around would be to add a case insensitive
field to your database, and use upper/lower before you insert the data.

Yes, that's not a very nice solution...

Matt Lewis