V4MD "Search a string case insensitive ..."

[info at vallemediatime.com]

Thanks Eric and Heinrich
I will try your suggestion in next week, because
in this days I must work for update a old project in V1.11
Paolo


----- Original Message ----- 
From: "Heinrich Ruoff" <heinrichruoff at gmail.com>
To: "Valentina Developers" <valentina at lists.macserve.net>
Sent: Saturday, July 09, 2005 11:04 AM
Subject: Re: V4MD "Search a string case insensitive ..."


Hi Paolo,

to make your db case insensitive in general try
gDb.setCollationAttribute(#kStrength, #kPrimary)
before adding tables and fields.

Heinrich

On 7/9/05, Erik Scholtz <anomar at elitecoderz.net> wrote:
> info at vallemediatime.com wrote:
> > I try to ask again...
> > It's so hard to answer?  :-)
> > Paolo
> >
> > ----- Original Message -----
> > From: <info at vallemediatime.com>
> > To: "Valentina Developers" <valentina at lists.macserve.net>
> > Sent: Friday, July 08, 2005 11:55 AM
> > Subject: V4MD "Search a string case insensitive ..."
> >
> >
> > Hi Ruslan and Igor,
> > I've not found the request example (Mantis #881)
> > "Search a string case insensitive in all one table in V4MD"
> > where have you put it?
> > Thanks
> >
> > Paolo
> 
> Hi,
> 
> I don't know where the example is, but try something like this:
> 
> SELECT col1,col2,col3
> FROM table
> WHERE LOWER(column4)=LOWER('seArchString')
> 
> This will make the search case-insensitive. Perhaps there is an option
> on valentina I don't know, but I think this is a easy, working way.
> 
> Best regards,
> Erik
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina



-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.11/44 - Release Date: 08/07/2005